Transactions in Access

[Walter Levine]

Are ADO transactions supported in Access?
the thing I cannot do is to create an SQL Transaction object i.e.
Dim myTran as SQLTranaction
there seems to be no such thing
Cans someone point me to documentation that explains how to do it?
thanks

 

[Sylvain Lafontaine]

The SQLTransaction class are for the .NET framework and ADO.NET. ADO and
ADO.NET are two very different things and cannot be mixed.

ADO transactions are supported under Access if you are using ADO objects.
You can use the first workspace of the DBEngine to work with transaction in
exactly the same way as with DAO. However, for bound forms, mixing your own
transactions with the transactions created by Access for the bound form is a
recipe for a disaster.

 

[Graham R Seach]

But ADO transactions are at Connection-level.

Dim cn As ADODB.Connection
'- - - -
cn.BeginTrans
'- - - -
cn.CommitTrans

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------