Link to a database in the "current" folder

  • Thread starter Thread starter John Avitt
  • Start date Start date
J

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
 
That's they way Access works.
You could always write a startup function that relinks the tables to a known
relative path
 
Back
Top