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 wrote:
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:?