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