Relative Path for a Linked Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)
 
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.
 
Back
Top