WORKING WITH TABLES USING ADO
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.
Looking at 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.
Object Type | Description |
---|---|
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. |
SYSTEM TABLE |
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.