VBA commitment

[twgonder]

I'm just about to start on a project that will have some VBA code updating multiple records in multiple tables.

I haven't yet seen a good class on the transaction commitment features in Access.
Has anyone got a nice simple demo db that shows the proper way to implement it?

Thanks

[June7]

Here is one example:

Private Sub btnDelete_Click()
Dim cn As ADODB.Connection
Set cn = CurrentProject.Connection
cn.BeginTrans
If DeleteTests(Me.LABNUM, Nz(Me.lbxMaterial, "")) = True Then
    cn.CommitTrans
    booTestsEdited = True
    Me.Refresh
Else
    cn.RollbackTrans
    MsgBox "There was a problem deleting all lab tests.  Contact Administrator", , "RemoveTestsError"
End If
Me.cbxTests.SetFocus
End Sub

[orange]

See this article on using transactions in MS Access by Philipp Stiefel