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.
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.