Q: Relative path for linked tables?

[Guest]

Hi,

I will have two Access 2000 databases which will be in the same folder. I
want to link one table in one database to the other database. Far as I can
tell, access puts the full path, ie
c:\folder\subfolder\foo.mdb

I would like it so that the link path is
..\foo.mdb

these two databases will be replicated on different servers. the full path
will change, but the relative path stays the same (both the databases in the
same folder). but since access stores the full path, I have to refresh the
link for each server.

 

[Todd Shillam]

Mark,

Are you using drive mapping or UNC mapping? I think I would use drive
mapping in your scenario. If you have questions, just post a reply or
send me an e-mail.


--
Best regards,

Todd Shillam
Information Technology Consultant
Shillam Technology
http://shillamtechnology.point2this.com

Hi,

I will have two Access 2000 databases which will be in the same folder.
I
want to link one table in one database to the other database. Far as I
can
tell, access puts the full path, ie
c:\folder\subfolder\foo.mdb

I would like it so that the link path is
..\foo.mdb

these two databases will be replicated on different servers. the full
path
will change, but the relative path stays the same (both the databases in
the
same folder). but since access stores the full path, I have to refresh
the
link for each server.