Show All

RollbackTransaction Event

Occurs just after Microsoft Access signals to the server that a batch transaction is to be rolled back.

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 occurs if a batch update was not successful because some error occurred while trying to commit the batch transaction. Any changes to the data made at this point are made outside the batch transaction.

You cannot cancel a transaction rollback; any attempt to correct the error takes place inside a new batch transaction.

Example

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

Private Sub Form_RollbackTransaction(Connection As ADODB.Connection)
    MsgBox "Access has rolled back the batch transaction on " _
        & Connection.Name & "."
End Sub