Hi Everyone. I have some tables that are being accessed through ODBC and everytime I open the database, the only way I can get these tables to work is go through the linked table manager and refresh them.

Is there a way to do this automatically when the database is first opened or does anyone have any code I could use for this? Or, better yet, is this the correct way to solve this problem?

Thanks

ru1

ru1,

Check out help on refreshlink in your vba code help.

Kevin

dartcoach