Relative Path for a Linked Table

[Guest]

I'm looking for a way to have a linked table with a relative path from the
current database. I have 2 different databases in folders, under a main
folder. This main folder gets moved often and I would like it so that I did
not have to refresh my linked tables manually between the two databases. Is
this possible?

 

[Allen Browne]

No. Access does not support relative paths in the Connect property of a
TableDef.

 

[david epsom dot com dot au]

No, linked tables cannot use relative paths. You can link
to a relative path, but it is automatically converted to the
absolute path.

Two alternatives are:

1) create a named share or subst a drive letter that you can
use to map the absolute paths.

2) Add code to your application to automatically re-link using
the relative path.

(david)

 

[Albert D. Kallal]

It is quite easy at startup to check if the path name to the back end
resides in the same dir..and if it does not..then simply re-link to the back
end found in the current dir.

So, while you can't set permanent link that is relative...with a bit of
coding..you get the same results....

Most of us simply grab the code here that re-links.

http://www.mvps.org/access/tables/tbl0009.htm

Throw in a bit of extra code..and you can freely move around the backend
and front end on your computer..and if you do move it...your code will
simply re-link.