Repairing Linked Tables

[gregsedwards]

I'd like my app to detect whether or not the linked tables used by my interface MDB are still there whenever the application is launched.

I suppose I can attempt to connect to the linked table using DAO, by executing an SQL statement against the table, or by opening the table in VBA. If anyone has a recommendation, please let me know.

Provided the table isn't accessible, I'd like to display a notice and give the user the choice to search for the file containing the table (perhaps open a File common dialog). I think I can handle that, but again any pointers would be appreciated.

Can anyone advise me (main question) about the best way to repair the missing linked tables using VBA, provided I have the name of the file that contains the tables?

Thanks in advance!

Greg Edwards

 

[StarPassing]

Check out MVPS.org. Search for "relink". You'll see many. One is "Relink Access Tables From Code". This should answer your question.

 

[gregsedwards]

Thanks!!

Greg Edwards