Возможно ли использование транзакций в Access ?
Попробовал с ADO - даёт ошибку: No transaction is active.
Система: win98, Access 97. MS Acsses driver v.4.00, ADO v. 2.0 , ADOR v. 2.7.


CODE:

Dim Con As ADODB.Connection
Dim Rec As ADODB.Recordset
Set Con = New ADODB.Connection
Set Rec = New ADODB.Recordset
Con.ConnectionString = "DSN=MyDSN"
Con.Open

If Con.State = adStateOpen Then
Rec.Open strNewRecord, Con, adOpenDynamic, adLockPessimistic, adCmdText
Else
DoCmd.SetWarnings True
MsgBox "Some error has occured while trying to perform the procedure. Try again later."
Set Rec = Nothing
Set Con = Nothing
Exit Sub
End If

On Error GoTo transerror

Con.BeginTrans
' ЗДЕСЬ ОШИБКА И УХОДИМ НА:
transerror:
Con.RollbackTrans

' И ПОЛУЧАЕМ ВЫШЕОПИСАННОЕ СООБЩЕНИЕ