Transactions Property

See AlsoproTransactionsSee

Applies To

Table object5RHH0MW, Dynaset object25TLT8.


Indicates whether a TableK31GNT or DynasetUDR386 supports the recording of a series of changes that can later be rolled back (canceled) or committed (saved).  Not available at design time; read-only at run time.




The Transactions property settings are:

Setting             Description


True                 The Table or Dynaset supports transactionsAGBRTK.

False                The Table or Dynaset doesn't support transactions.



The recordset is the Recordset property of a data control.  In the Professional Edition, it can also be an object variableZ3R9Q5 identifying an open Table or Dynaset.

If the recordset is based entirely on Microsoft Access tables, the value of the Transactions property is True and you can use transactions.  Tables created by other database products may not support transactions.  For example, you cannot use transactions on a Paradox table.

Before you use the BeginTrans statement, inspect the value of the Transactions property to make sure the recordset supports transactions.  If Transactions is False, using BeginTrans or Rollback has no effect on this object.  It may, however, affect other objects since the scope of transactions covers all database items.