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.

Table 6.4. Table Type Objects Stored in the 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.