Any way to make relative links?

[Magritte]

I have some databases that link to tables in other databases. The problem is
I sync across 2 computers and the location of the databases differs in drive
letter on the 2 computers.

This causes the link to fail on whichever computer wasn't the last to edit
the database and I have to manually re-link the tables each time I move
between computers.

I tried setting an environment variable to define the root folder then set
up the links using the environment variable, but it just ends up expanding
the environment variable to a fixed path so that it doesn't help.

Is there any way to set up the links so that they remain intact across
computers or maybe set them up as relative links based on the databases
current location (they're all actually in the same folder anyway) rather than
as full path links?

Thanks!

 

[Jeff Boyce]

Magritte

You haven't described the network configuration that allows these PCs to
communicate. "How" may depend on "what"...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Beetle]

Use UNC path naming instead of Drive Letter path naming, so the path will
look like;

'\\ServerName\SomeFolder\YourBE.mdb

If you navigate to the BE using My Network Places you will get UNC paths.

_________

Sean Bailey

 

[Magritte]

Hi,

Thanks for the replies. I think I need to clarify a bit.

I'm not attempting to access the databases from multiple computers on a
common network. I'm simply synchronizing (copying the latest version) of each
database between multiple computers so that I can work on the databases from
any of the computers. But each computer is accessing the databases from its
own local hard drive.

However, due to the way the file systems are set up, the most convenient
location to store the files on each computer is not always on the same path.

The link between databases, also, is not across the network or to a server,
but simply a linked table from one local database to another local database
(which currently resides in the same folder). I could import the tables
rather than use a link, but since some of the tables are very large and act
as references to a number of different databases it makes sense to me to link
instead of duplicate. It also simplifies updating the referenced table
without having to then manually import to each other database that references
it.

In the meantime I created a symbolic link in the same path on the C: drive
on the computers I sync the files to. I imagine if I refer to the files
through the symbolic link this should solve the issue. It seems like a rather
extreme approach though so I'm still curious if there's any way to get Access
to view database links as relative rather than absolute paths.

Thanks!