VBA Linked Table Manager

[TarBall]

I have successfully automated the refresh of my linked tables using VBA (thanks to a post on this forum -- Cool). Anyway, what I would like to know now is this:

If my table collection does not have any linked tables, using VBA, how can I get that list of available tables to show? Assume that I will be connecting to the same database (Oracle) through an ODBC connection. I dont wish to change the connection - just want that window with all tables to shouw up.

Thanks guys/gals for the help.

 

[Pat Hartman]

The linked tables manager is only used for changing or refreshing existing links. If you want to add new linked tables go to File/Get external data/Link