Automatic Foreign Table Linking Refresh

[beanbrain]

All:

I have an Access 97 application that links to external tables and then generates reports from them. Everything works beautifully except I would also like to automate refreshing the links to the foreign tables.

I have installed the "Linked Table Manager" add-in and would like to:

a) Have the Linked Table Manager dialog pop-up prior to processing.

or

b) Automatically relink all of the tables I use.

Thanks

 

[SMerrill]

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

 

[beanbrain]

I tried the code from the site suggested and though it works I have tables to re-link to from a number of different directories. The Add-in "Linked Table Manager" is really going to be the best way to re-link tables before report generation.

It would be preferable to have a "DoCmd.DoMenuItem" type command that will execute the Add-In. Problem is I can't find any reference to accessing an Add-In with either "DoMenuItem" or "RunCommand."

 

[beanbrain]

OK...figured it out.

sendkeys "%til" ' Tools addIn Link