ADO Object Model Summary

Microsoft ActiveX Data Objects (ADO)

ADO Object Model Summary

ADO Object Summary

Object Description
Connection Enables exchange of data.
Command Embodies an SQL statement.
Parameter Embodies a parameter of an SQL statement.
Recordset Enables navigation and manipulation of data.
Field Embodies a column of a Recordset or Record object.
Error Embodies an error on a connection.
Property Embodies a characteristic of an ADO object.
Record Embodies a directory or file.
Stream Embodies the content of a file.

ADO Collection Summary

Collection Description
Errors All the Error objects created in response to a single failure on a connection.
Parameters All the Parameter objects associated with a Command object.
Fields All the Field objects associated with a Recordset object.
Properties All the Property objects associated with a Connection, Command, Recordset, or Field object.

ADO Event Handler Summary

ConnectionEvents Description
BeginTransComplete,
CommitTransComplete,
RollbackTransComplete
Transaction Management — Notification that the current transaction on the connection has started, committed, or rolled back.
WillConnect, ConnectComplete, Disconnect Connection Management — Notification that the current connection will start, has started, or ended.
WillExecute, ExecuteComplete Command Execution Management — Notification that the execution of the current command on the connection will start, or has ended.
InfoMessage Informational — Notification that there is additional information about the current operation.

RecordsetEvents Description
FetchProgress, FetchComplete Retrieval Status — Notification of the progress of a data retrieval operation, or that the retrieval operation has completed.
WillChangeField, FieldChangeComplete Field Change Management — Notification that the value of the current field will change, or has changed.
WillMove, MoveComplete, EndOfRecordset Navigation Management — Notification that the current row position in a Recordset will change, has changed, or has reached the end of the Recordset.
WillChangeRecord, RecordChangeComplete Row Change Management — Notification that something in the current row of the Recordset will change, or has changed.
WillChangeRecordset, RecordsetChangeComplete Recordset Change Management — Notification that something in the current Recordset will change, or has changed.