URL for linked tables - shared database 1

[jjlogan]

I can't find any answers in this forum or Access help files. Here's the background and problem.
My Access 2000 file is to be shared by multiple users. The shared file contains links to tables in another Access file on the same shared drive in our network. Each of the users refers to that shared drive using a different mapped letter (E, F, P, etc.). Microsoft Access help file states we should use the universal reference (URL I believe its called). I can't figure out where to change the link references for the tables; right now the reference uses my mapped letter K:\. The application to be shared is real simple - an executive reporting system with just a couple reports. There isn't much need for VBA except to move from my Opening menu to the Reports form. The reports are created form queries in this application operating on the linked tables. I have used URL in code before and that is easy because the reference is accessible in the code, but for this application, I'm hoping to avoid vba for the linking since I used the File menu / Get External / Link approach.
Thanks for any insights and ideas.
Jeff

 

[jksmi]

hi jjLogan,

have a look at thread700-840593, about half way down there is a solution to your problem by NorthNone (followed by a variation from me)

HTH, Jamie
FAQ219-2884

 

[sxschech]

Perhaps what you need instead of URL is UNC. Change your linked tables to refer to the UNC form of the file path and this should resolve your issue. Example:

Before:
K:\Files\Database.mdb

After:
\\systemproj9519\Project\Files\Database.mdb

You can find the UNC for your "K" drive several ways:
At the DOS prompt type NET USE
C:\>net use
New connections will not be remembered.


Status Local Remote Network

--------------------------------------------------------------------------
OK K: \\SYSTEMPROJ9519\Project Microsoft Windows Network


Also, this information is available through windows under My Computer and looks like:

Project on SYSTEMPROJ9519 (K

Thus, when you relink the table, you would type into the FileName Box \\SYSTEMPROJ9519\Project\Files\Database.mdb

[Remember to replace with the actual UNC and not the one shown in the example]

 

[jjlogan]

Thanks Jamie and Sxs for the help!!
The problem is solved using the suggested thread and I got extra related information as well. I wanted to change the references to the linked tables in my shared database from mapped letter to UNC. I did this within my application using menu Tools/Database Utilities/Link Manager. The key was to click the checkbox "Always prompt for new location" at bottom of screen in Link Manager, and then click the My Network Places to use UNC.
Jeff