Changing Linked Table Path

[JK]

I have a split database where the back end is stored on a network drive.
Depending on the computer the network drive name can be different. For
example, I have the network drive mapped as R: when someone else can have it
mapped on their computer as the Z:. The name of the drive is actually
\\fadsf-afs.

When I split the database, the path to all the linked tables start with R:,
so when other people who mapped the drive as Z: they get an error.

How do I save the beginning of the path as \\fadsf-afs instead of R:?

 

[John Spencer MVP]

If you use the built-in Linked Table Manager tool to set links navigate to
your network places and find the server fadsf-afs and navigate down to your
database that way. When you finish linking the R: will be replaced with the
server reference \\fadsf-afs

If you use some other method to set the path, then we would need to know the
code you are using.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[JK]

Thanks for the reply.

I tried to navigate through using the network places, however I cannot
access the folders on the server that way. The next folder down on the
server is not an option. (Ex. \\fadsf-afs\ew$) I can type that in a
windows explorer and get to the folders I need, but when I use the network
places ew$ is not an option I can select. I'm 100% positive that I am
navigating to the correct server when using network places.

I do not know how to correctly set the path using code. I'm pretty new to
writing code in Access so my knowledge on the correct syntax and where to
place the function, like when the program opens or when a form opens, is
limited. I don't even know how to run a function when the program is first
opened automatically.

If I have the people just change the path manually using the link table
manager on the front end they have on their computer, will this resolve the
issue?

 

[John Spencer MVP]

You might check out the following URL that has code to link tables.
http://www.mvps.org/access/tables/tbl0009.htm

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County