Working with tables in ADO is similar to working with them in DAO. Instead of working with the TableDefs collection, you will be working with the Tables collection.
The Tables collection is located off the Catalog object. One difference between ADO's Tables collection and DAO's TableDefs collection is that more than just standard table and link table objects are stored in it. Table 6.4 lists the object types in the ADO Tables collection.
|ACCESS TABLE||Access system table.|
|LINK||Linked table from a non-ODBC data source.|
|PASS-THROUGH||The table is a linked table from an ODBC data source.|