Unanswered: Determine the link type of Table in VBA
When I enumerate through the tables collection - how can I determine the link type - ie. ODBC, or mdb etc.
basically what I am doing is writing a startup procedure that will delete the link of my odbc tables and reattach them and then truncate the dbo_.
I have the reattach and renaming down - I just need to determine the link type. The hack work around is to store the tablenames in a table and if the table name is found - then delete it - but this is not a very clean way - any ideas guys?