ADO Collections and Objects

The ADO object model is structurally simpler than either DAO or Visual Basic’s RDO object model. The Connection object is the top object in the hierarchy and represents a connection to a data source. This object contains the Command and Recordset objects as well as the Errors collection. Table 12.4 defines the functions of the main ADO object model components.

Table 12.4. ADO Object Model Functions
Object or Collection Function DAO Nearest Equivalent
Connection Create a connection to a data provider Database Object
Recordset Create a recordset using a query Recordset Object
Command Execute SQL strings, action queries, or stored procedures QueryDef Object
Errors In the event of an error, one or more errors is inserted ...

Get Access 2002 Programming by Example 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.