re-linking tables in a split data base

[CD Tom]

I distribute my database to many users, so users have the
database located in the C:\program files\xxx directory
while others have theirs located in a different directory
within c:\program files. Is there an easy way to find
the database and re-link it? Right now I have to re-link
the database before I send out any updates, the more
users I have the longer this takes.

Thanks for your help
Tom

 

[Sandra Daigle]

Take a look at this code:

http://www.mvps.org/access/tables/tbl0009.htm