Table object, Dynaset object.
Indicates whether a Table Not available at design time; read-only at run time. or Dynaset supports the recording of a series of changes that can later be rolled back (canceled) or committed (saved).
The Transactions property settings are:
True The Table or Dynaset supports transactions .
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 variable 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.