O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required