Linked Tables path

[dgmorr]

Hey guys,

Is there a way to update the path of a linked table manually? The network drive on my computer is mapped to the letter V: but on other users this could be different. How can I set the location so that it just searches for the name of the server (ie. //ServerName/db1.mdb) instead of a hard path?

 

[boblarson]

Go into the linked table manager and select the checkbox "Always Prompt for New Location" and click the select all button, then type the whole UNC path and file name into the place on the bottom of the dialog (File Name) that comes up when you click OK.

 

[dgmorr]

Thanks! This site has been a great help!