J
Jean-Marc
Hi,
I am unable to have transactions working.
Using Access 2003 on a straight .mdb database.
In the VBA code of a Form callback function:
CurrentProject.Connection.BeginTrans
Dim rsTAnnee As New ADODB.Recordset
rsTAnnee.Open "SELECT * FROM Annee", CurrentProject.Connection,
adOpenDynamic, adLockOptimistic
rsTAnnee.AddNew
rsTAnnee!annee = 1999
rsTAnnee.Update
CurrentProject.Connection.RollbackTrans
when execution reaches 'RollbackTrans', the system always throw the
error: 'You tried to commit or rollback a transaction without first
beginning a transaction'
I checked the connection and the 'Transaction DDL' property is defined.
I am unable to have transactions working.
Using Access 2003 on a straight .mdb database.
In the VBA code of a Form callback function:
CurrentProject.Connection.BeginTrans
Dim rsTAnnee As New ADODB.Recordset
rsTAnnee.Open "SELECT * FROM Annee", CurrentProject.Connection,
adOpenDynamic, adLockOptimistic
rsTAnnee.AddNew
rsTAnnee!annee = 1999
rsTAnnee.Update
CurrentProject.Connection.RollbackTrans
when execution reaches 'RollbackTrans', the system always throw the
error: 'You tried to commit or rollback a transaction without first
beginning a transaction'
I checked the connection and the 'Transaction DDL' property is defined.