Microsoft Office Tutorials and References
In Depth Information
The ADO Object Model
There are three main objects in the ADO object model. (See Figure 23-2.) The Connection
object represents the information needed to establish the connection between the data
consumer and the data provider. The Command object contains information about an
SQL statement or other database command that will be executed by the database server.
The Recordset object contains the rows from the virtual table that was created by the
A few key objects comprise the ADO object model.
In addition to these objects, there are also a few other objects that support these main objects.
Those supporting objects are the Error object, which contains information about any errors
that occur, and the Parameter object, which contains information about any parameters
associated with the Command object. The Field object contains information about a column
returned in the Recordset object.