Link to a database in the "current" folder

[John Avitt]

I want to link tables from a second database file that will always reside in
the same folder as the first. Both files may be moved to another folder on
occasion, or the folder structure may change, over which I have no control.
Why can't I simply use the current folder notation (i.e. ".\Data.mdb" or
even ".\SubFolder\Data.mdb") for the linked tables? Every time the folder
gets moved, or one of the folders in the hierarchy gets a name change, the
table links break.

Thank you.

John

 

[Guest]

That's they way Access works.
You could always write a startup function that relinks the tables to a known
relative path