AfterBeginTransaction Event

Microsoft Access Visual Basic

Show All

AfterBeginTransaction Event

       

Occurs just after Microsoft Access signals to the server that a batch transaction is beginning with a batch update.

Private Sub Form_AfterBeginTransaction(Connection As ADODB.Connection)

Connection   The connection on which the batch transaction is taking place.

Remarks

This event applies to Access project forms whose BatchUpdates properties are set to True.

This event is used for any processing that needs to happen before Access commits any records inside a batch transaction. Any changes to the data made at this point are made inside the batch transaction.

Example

The following example demonstrates the syntax for a subroutine that traps the AfterBeginTransaction event.

Private Sub Form_AfterBeginTransaction(Connection As ADODB.Connection)
    MsgBox "Access has signaled to " & Connection.Name & " to " _
        & "begin a batch transaction for the current batch of updates," _
        & "but has not yet committed any records to the server."
End Sub