Back End Database Linking and Drive Mapping

[AKoval]

Hi everyone.



I have an interesting problem. I have built a Database thank links to multiple back end databases.The whole database is completed, and I have to share it across the company, so I have placed the Database and all of the Back End databases on a "public" shared drive. I have the "public" drive stored as my Q drive. So when I link to the back end databases, the path it stores is Q:\Databases\Database.accdb

However, the problem is that not everyone will have the "public" drive mapped to Q. It's possible they could have it mapped to P or A or whatever. So if someone has their "public" drive mapped to P, this database will not work (since Q:\Databases\Database.accdb would not exist for them - it's really P:\Databases\Database.accdb).

Is there a way around this? So that instead of it mapping to the relative letter (Q or P), can it just refer to "public"?

Thanks for your help!
Tony

[June7]

Set the table links with UNC pathing. UNC = Universal Naming Convention. This pathing uses the server name instead of mapped drive. The structure is: \\servername\path\filename

Review https://www.accessforums.net/access/...end-27089.html

[AKoval]

Awesome! Big thanks!! I was almost thinking it was hopeless.