Transactions Property

Applies To

Database Object, Dynaset-Type Recordset Object, Recordset Object, Snapshot-Type Recordset Object, Table-Type Recordset Object.

Description

Returns a value that indicates whether an object supports the recording of a series of changes that can later be rolled back (canceled) or committed (saved). True (-1) indicates that the object supports transactions. Snapshot-type Recordset objects always return False (0).

Remarks

You can use the Transactions property with dynaset- or snapshot-type Recordset objects.

If a dynaset or table is based on a Microsoft Jet database engine table, the Transactions property is True and you can use transactions. Other database engines may not support transactions. For example, you can't use transactions in a dynaset-type Recordset object based on a Paradox table.

Check the Transactions property before using the BeginTrans method on the Recordset object's Workspace object to make sure that transactions are supported. Using the BeginTrans, CommitTrans, or Rollback methods on a nonsupported object has no effect.