Returns a value that indicates whether an object supports transactions.
Syntax
BOOLGetTransactions(VOID);
Remarks
In an ODBCDirect workspace, the Transactions property is available on Connection and Database objects and indicates whether or not the ODBC driver you are using supports transactions.
In a Microsoft Jet workspace, you can also use the Transactions property with dynaset- or table-type CdbRecordset objects. Snapshot- and forward-only–type CdbRecordset objects always return False.
If a dynaset- or table-type CdbRecordset 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 CdbRecordset object based on a Paradox table.
Check the Transactions property before using the BeginTrans method on the CdbRecordset object's CdbWorkspace object to make sure that transactions are supported. Using the BeginTrans, CommitTrans, or Rollback methods on an unsupported object has no effect.