ADO Event Handler Summary

ADO events are grouped into two families. The ConnectionEvent family pertains to operations on the Connection object, and the RecordsetEvent family pertains to operations on the Recordset object.

ConnectionEvents — Events are issued when a transaction on a connection begins, is committed, or is rolled back; when a Command executes; when a warning occurs during a ConnectionEvent operation; and when a Connection starts or ends.
RecordsetEvents — Events are issued around asynchronous fetch operations, as well as when you navigate through the rows of a Recordset object, change a field in a row of a Recordset, change a row in a Recordset, open a Recordset with a server-side cursor, close a Recordset, or make any change whatsoever in the Recordset.

ADO Event Handler Summary

The following tables summarize the events and their descriptions.

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

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