• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Access Visual Basic Tools, T... > ADO Collections and Objects

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 into this collection Errors Collection



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint