How to identify ODBC linked tables in code? 1

[AMadden]

I'm in the process of upgrading a VBA application from Access 95 to 2000. Part of this process is switching from the use of DAO to ADO/ADOX.

I'm having a problem converting the DAO code which checks the Connect property of every table (tabledef) in the database and determines which tables are "ODBC Linked."

Does anyone know how to identify ODBC Linked tables using ADO/ADOX? Any help with this would be appreciated. I may be spending a long weekend....

Thanks
-Art Madden

 

[cmmrfrds]

This article shows how to link/relink both DAO and ADOX tables. You should be able to find what you need in it.

http://www.appdev.com/Documents/acsqlch5.PDF

 

[rajeessh]

Dim tdf as TableDef
For each Tdf in Currentdb.TableDefs
IF tdf.connect like "ODBC*" Then
'your code goes here
End if
Next tdf

Have DAO reference added