automate refreshing linked tables

[Rosie]

is there a way to automatically refresh a linked table
when the database is opened instead of having to do it
manually?

 

[Roger Carlson]

Yes, although the specifics of how to do it will vary with the specifics of
your system. On my website (see sig below) is a small sample database
called "RelinkOnOpen.mdb" which illustrates one way.

 

[Joe Fallon]

For Jet re-linking code see:
http://www.mvps.org/access/tables/tbl0009.htm