I suggest you purchase a copy of "Access 2000 Developers Handbook" by Ken
Getz and company, published by SYBEX. This 2 volume set is available from
Amazon.com at a discount. In this book Ken Getz provides a very good
discussion linked table manager. Also included is a great routine to
automatically check for links, fix broken links and tell the user that there
is a problem and how the user can select the database to link to. The book
includes a CD with all the databases they use in the book and all the neat
routines they use too. Easy to read and a great reference.
The same authors have a new 2 volume set for Access 2002 Developers
Handbook.
Cheers,
Henry