link tables always moving

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

Guest

I work on my database on multiple computers off of a flash drive. I have all
my tables in database 1 linked to database 2 where all my formsand so forth
are. But everytime i move computers and get a different drive letter
assigned to my flash drive i have to go back and delete and relink all of
those tables again. Is there anyway to link the tables with some sort of "./"
option much like you can with HTML code, so it looks in the current folder no
matter where it is actually mapped to instead at the entire file path?

thx
 
The option you envision does not exist per se. However, the effect you want
can be achieved in a couple of ways. For one, you can relink all your
tables quite quickly by using the Linked Table Manager. If you don't mind
writing a little VBA code, you can create a function which runs when the
database opens and relinks all your tables.
I think you'll find some pointers at www.mvps.org/access.
 
Back
Top