Share via

Error message "Not a valid path"

Anonymous
2011-06-08T21:44:46+00:00

I have a database (Commercial DB) that is link to another other database (Production DB) within the same folder on my intranet.   I have a dozen people that have no problem working with these databases.  I have three individuals that are able to open the database to the switchboard, but once they “click” any of the buttons on the switchboard they get an error message indicating that “Production DB” is not a valid path?  Why would the majority of the users have no problem and a select few do?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-06-08T22:15:43+00:00

    You probably linked the tables based on a drive letter mapping when you should have used UNC (Universal Naming Convention) so that it wouldn't matter that users had different mapped drives.

    You can use the Linked Table Manager to put in the UNC path.  Just open the Linked Table manager and then select the tables to be relinked (select only those for a single data source at a time though) and then click the Always Ask checkbox.  Then when the browse comes up you can browse to the location using My Network Places > Entire Network > and so on down the line.  Or you can figure out the UNC path and then just type it in the bottom box of the dialog that came up to select the database:

    Also, I hope that these databases are SPLIT (frontend / backend) with the frontend as a COPY on EACH user's machine.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-06-09T00:44:44+00:00

    Yes i did link the table on a particular drive.  This drive is a manufacturing drive and the letter is the same for every computer.  The company set it up this way.  Yes, the databases are split, the Commercial DB is the fronted and the production DB is the backend.  Do i still think I need to change the linkage to a UNC?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-06-09T01:23:51+00:00

    Another issue to consider - do all the users (these in particular) have the frontend database in a Trusted Location? Does your database have any automatic relinking code? What format is their frontend file: mdb, mde, accdb, accde?

    Was this answer helpful?

    0 comments