Mahonek
asked on
Windows cannot find g:\folder\folder\name.mdb
i had a server (win2000) go out on me and needed to reinstall the operating system and recover some databases from a backup tape. two databases have similar vba code in them and run using a autoexec macro to open a progress form as the queries update in the background. This used to work without errors prior to the rebuild, etc. Now, one of them works fine with an error but the other one gives me the following error and after clicking "OK" continues running the code and updating.
MESSAGE: Microsoft Access cannot find g:\folder\folder\name.mdb
The pathfile is correct, because my user is using a shortcut to the database to run the program.
I verified the permissions which seem to be accurate.
I compare the two shortcuts to both DB's and they are the same.
Can someone help me identify what could be wrong? Thanks.
MESSAGE: Microsoft Access cannot find g:\folder\folder\name.mdb
The pathfile is correct, because my user is using a shortcut to the database to run the program.
I verified the permissions which seem to be accurate.
I compare the two shortcuts to both DB's and they are the same.
Can someone help me identify what could be wrong? Thanks.
ASKER
Ok, when I run it from dos I get the similar popup message
Windows cannot find g:\folder\folder\name.mdb
and the dos message:
The System cannot find the file g:\folder\folder\name.mdb
The crazy thing is that it continues the update.
Windows cannot find g:\folder\folder\name.mdb
and the dos message:
The System cannot find the file g:\folder\folder\name.mdb
The crazy thing is that it continues the update.
Use the Tools, Database Utilities, Linked table manager.
If Access opens a window,
Look for a table in the list using g:\folder\folder\name.mdb.
Put a check on this line an one in Always Prompt for New Location
Browse to locate the name.mdb and choose OK.
The links should refresh.
If your problem persists, recheck security on the g:\folder\folder
You must permit this user to Create files. When Access opens a database, it creates a file for record locking. In this case, name.ldb. If you are running your database and don't see the name.ldb file in the folder, this is your problem.
If Access opens a window,
Look for a table in the list using g:\folder\folder\name.mdb.
Put a check on this line an one in Always Prompt for New Location
Browse to locate the name.mdb and choose OK.
The links should refresh.
If your problem persists, recheck security on the g:\folder\folder
You must permit this user to Create files. When Access opens a database, it creates a file for record locking. In this case, name.ldb. If you are running your database and don't see the name.ldb file in the folder, this is your problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I relinked the tables and There are no .ldb files for either database in the folder with the mdb's. I checked the securities (the databases are both in the same folder) for the folders. Still having the problem where one runs fine and one gives me the error. The code in both database modules are the same the only differences are the linked tables. Still checking. Thanks.
Mahonek
Mahonek
Otherwise search for g:\folder\folder\name.mdb in your code and paste that procedure here.