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.
MahonekAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 DanekeTrainerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.