You must use BeginTrans, CommitTrans, Rollback. After the BeginTrans method starts a transaction that isolates all the changes made to the database, the CommitTrans method saves the changes. You can use the Rollback method to undo changes that you saved using the Update method.

For sample:

Dim cnn1 As ADODB.Connection

' Open connection...

' Start a transaction.
cnn1.BeginTrans

' Change database...

' Ask if the user wants to commit to all the changes made above.
If MsgBox("Save all changes?", vbYesNo) = vbYes Then
cnn1.CommitTrans
Else
cnn1.RollbackTrans
End If

Best regards.

------------------
smalig
[email protected]
smalig.tripod.com