See Also
Applies To
Table object, Dynaset object
Description
Indicates whether a Table Not available at design time; read-only at run time.
Syntax
recordset.Transactions
Setting
The Transactions property settings are:
Setting Description
True The Table or Dynaset supports transactions .
False The Table or Dynaset doesn't support transactions.
Remarks
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.