link tables always moving

[Mulequi]

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

 

[MacDermott]

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.