ADO Events

ADO 2.0 supports events. An event is a notification issued by certain operations before the operation starts or after it completes. An event is actually a call to an event handler routine that you define in your application. See ADO Event Instantiation by Language.

There are two families of events. The ConnectionEvent family pertains to operations on the Connect 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, and when a Connection starts or ends.
RecordsetEventsùEvents are issued 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, or make any change whatsoever in the Recordset.

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, or 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 of any ConnectionEvent event.

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.