Windows cannot find g:\folder\folder\name.mdb

Posted on 2006-03-31
Last Modified: 2011-10-03
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.
Question by:Mahonek
    LVL 39

    Expert Comment

    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.

    Author Comment

    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.
    LVL 18

    Expert Comment

    by:Richard Daneke
    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.
    LVL 39

    Accepted Solution

    >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.

    Author Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now