• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

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.
0
Mahonek
Asked:
Mahonek
  • 2
  • 2
1 Solution
 
thenelsonCommented:
Try opening a DOS window, paste g:\folder\folder\name.mdb into the command line, press return and see what you get.

Otherwise search for g:\folder\folder\name.mdb in your code and paste that procedure here.
0
 
MahonekAuthor Commented:
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.
0
 
Richard DanekeCommented:
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.
0
 
thenelsonCommented:
>and the dos message:

The System cannot find the file g:\folder\folder\name.mdb

Assuming G is a mapped drive, carefully double check that the drive is mapped correctly:  In the DOS window try G: return and very carefully check your spelling of the path and file names.  If you have spaces in the names, make sure they are single spaces and not multiple spaces.  Goto Network places and drill down to the folder that contains the file.  Highlight the file, Men copy and paste the address bar to your program.
0
 
MahonekAuthor Commented:
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  
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now