Linked tables - mapped drive issue (1 Viewer)

[yippie_ky_yay]

Hello,

I've got a split db and I need for the link between the two to be:
\\server\name\myBEdb.mdb
instead of:
S:\name\myBEdb.mdb

The server name will not change - so I don't need anything dynamic.

Will this need to be done via VBA and, if so, could someone point me in the right direction please? Also, if I do have to use VBA to dynamically set it, will there be a performance hit?

Thanks!

-Sean

 

[FoFa]

I use Linked Table manager to set the UNC path to my tables.
But I use Access 2002

 

[fuzzygeek]

When you do the link, type in the server name like you showed it or go to the Network to select the path. See the attached jpegs that show what I do.

 

[yippie_ky_yay]

Thank you both for your replies!

fuzzygeek's solution was exactly what I was hoping for (never occured to me to just type the link in there). Everything's working well!

Thanks again!

-Sean