Link Tables issues

[nosaj03]

Hey all,

Im having some link table issues that Im hoping you folks can help me with.

I have a client who has users in different locations. I have database A that houses some tables that are linked into database B which are located on drive X:\
The issue is since there are different locations, the X:\ is mapped differently through different IP address.

For example the X:\ in building A is mapped xxx.xx.xxx.xxx\X:\folder\database A.mdb and building B is mapped xx.xxx.xxx.xx\X:\folder\database A.mdb

How do I link the tables to just look at the X:\folder\database A.mdb without the IP designation?

I work remotely on a workstation that is located in Building A so my X:\ is mapped to the IP address specific to that building and when I try to refresh the links it keeps the IP designation for Building A that Building B cant access.

 

[Ranman256]

dont use hardcoded Drive letters, instead use UNC path names....

\\server\folder\folder\database.mdb

 

[nosaj03]

dont use hardcoded Drive letters, instead use UNC path names....

\\server\folder\folder\database.mdb

Thanks for the suggestion.

How do I use the UNC path name when using the link table manager?

 

[HiTechCoach]

Thanks for the suggestion.

How do I use the UNC path name when using the link table manager?

If you want to browse, go to network below the list of drives. When you expand network you should find all the machines by name.

 

[The_Doc_Man]

How do I use the UNC path name when using the link table manager?

Boyd's comments are absolutely correct. I'll add something from the raw mechanical viewpoint. As Boyd suggests, you determine the correct UNC path (and watch out for published "share" folders, they often have special punctuation.) The format will be something like "\\server\share-name\folder\folder\...\last-folder" - so what you do is type this ONCE into a text file somewhere.

Then, when you need to diddle around with the links, open this file in a separate window. Start your Linked Table Manager, switch windows to this file, highlight the UNC path, do a right-click Copy or a Control/C or (from Notepad) a menu Edit>>Copy. Then switch back to Access and the Linked Table Manager. Select the tables by checking the relevant boxes (or if appropriate, there is a Select All button). Tell it to update the links. When it offers you a dialog for the path, use a right-click Paste or a Control/V to get the path into the path textbox.

Doing it this way minimizes typing errors. You just have to get it absolutely right once, then let the machine type it for you the next time. You will be doing what Boyd suggested. I'm only telling you how to minimize the work of doing this more than a couple of times.