473,786 Members | 2,344 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

3044 Error - weird CurrentDB failure

Scenaria -
Access 2000 FE - 2 clients
Access 2000 BE - on a network server.

Tiny little application, all tried and tested code. Worked fine until
this morning, when users began receiving the following error:

Error Number 3044

C:\Projects\MyC lient\Data\MyCl ientData.mdb' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected
to the server on which the file resides.

The code which caused the error is:

strSQL = "DELETE * from tblRotaReportDa ta;"
CurrentDB.Execu te strSQL

Later, it also fails on
DoCmd.OpenRepor t "rptFullRot a", acViewPreview

The value of CurrentDB.Name in the Immediate pane is:

C:\Program Files\MyApp\Mya pp.mdb

which is correct.

Anyone any ideas? I'm moderately desperate, but my clients are tearing
their hair out!

TIA

Edward

Nov 13 '05 #1
1 5858
te********@hotm ail.com wrote:
Scenaria -
Access 2000 FE - 2 clients
Access 2000 BE - on a network server.

Tiny little application, all tried and tested code. Worked fine until
this morning, when users began receiving the following error:

Error Number 3044

C:\Projects\My Client\Data\MyC lientData.mdb' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected
to the server on which the file resides.

The code which caused the error is:

strSQL = "DELETE * from tblRotaReportDa ta;"
CurrentDB.Exec ute strSQL

Later, it also fails on
DoCmd.OpenRepo rt "rptFullRot a", acViewPreview

The value of CurrentDB.Name in the Immediate pane is:

C:\Program Files\MyApp\Mya pp.mdb

which is correct.

Anyone any ideas? I'm moderately desperate, but my clients are tearing
their hair out!

TIA

Edward


This looks like the tables are not correctly linked to the backend.
Use the Linked Table Manager to check for the actual locations of the
links.

HTH
Matthias Kläy
--
www.kcc.ch
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6901
by: Nathan Bloomfield | last post by:
Hi there, I am having difficulty with a piece of code which would work wonders for my application if only the error trapping worked properly. Basically, it works as follows: - adds records from rsSource into rsDest - if it finds a key violation then it deletes the current record from rsDest and adds the new record from rsSource. This works perfectly - but only for the first found duplicate record, it brings up the error
19
6274
by: MLH | last post by:
I call the following Sub and Function in frmLaunch's OnOpen event code. I keep getting Property Not Found error for the AllowBypassKey setting. Failure point is line #30 in the Function (not the Sub). Ideas? Sub SetStartupProperties() On Error GoTo SetStartupProperties_Err 10 ChangeProperty "StartupForm", dbText, "frmLaunch" ' Form you want to open at startup 20 ChangeProperty "StartupShowDBWindow", dbBoolean, False ...
3
15957
by: deko | last post by:
I have a logging routine that's supposed to silently log errors caught by error handler code on certain functions. The problem is sometimes stuff happens and the error handler can get caught in a loop. Is there some way to send a break from VBA code to break out of the loop? Here's what the error handler code looks like: Private Function MyFunction On Error GoTo HandleErr
4
1403
by: caa | last post by:
We are intermittently getting the infamous Configuration error: "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS." However, in our case the relevant directory is definitely configured as an IIS Application. I've done a lot of research online, and haven't found anyone else who gets this...
2
1531
by: Lisa Calla | last post by:
My aspnet web was working perfectly fine, then I added a second datalist to a page. The datalist can be formatted in the designer and everything looks fine. In the codefile, I can see the datalist after me. and intellesense works for the control datalist2. Build\Rebuild all reports a failure, but does not specify the errors. Running the page results in a message box 'There were build errors. Would you like to continue and run the last...
0
999
by: Howard | last post by:
I've been trying to fix this for a week now. I tried to migrate my asp.net 1.1 web apps to 2.0. No code changes, complied fine. the 2.0 version even worked on my dev machine (windows xp) But when I run it on my production server (windows 2003) I get this error. Server Error in '/' Application. -------------------------------------------------------------------------------- Instance failure. Description: An unhandled exception occurred...
5
2543
by: Alan Silver | last post by:
Hello, Server configuration: Windows 2003 Server SP2 SQL Server 2000 SP4 ..NET v2.0.50727 just built up a new server using the same configuration as my current one. I even used the same CDs and registration keys, so I'm certain that the two machines are as similar as they can be.
6
3372
by: itsolution | last post by:
Hi folks, Could you shed some light on this issue? my program is running on Freebsd as a daemon. When user sends a request, it forks itself and lets its child process handles the request. And its main role is just to read a big xml file and save each object into its embedded DB(such as gdbm).
8
2995
Cintury
by: Cintury | last post by:
The problem is I have a function that I've created and stored in a module. I call it as an expression (e.g. total: Function(parameter)). I'm receiving the error 3061: too few parameters, expected 1. Now the query and database are already open so I'm not entirely sure of any connection strings I may need. I think part of the problem may be that the parameter I am using to call the function is part of the query. I am not sure how to come by this...
0
9491
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10163
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10104
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9959
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8988
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5397
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5532
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4063
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.