ACC: DoCmd Statement in Transaction Not Affected by Rollback
ID: Q89587
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
In Microsoft Access, the DoCmd Object (or the DoCmd statement in version
1.x and 2.0) is not affected by a Rollback statement if the DoCmd Object
appears in a transaction.
MORE INFORMATION
Transaction processing in Microsoft Access is valid only on virtual
table (VT) objects, such as dynasets. The DoCmd Object starts another
Microsoft Jet database engine session to process its arguments.
Because the Jet database engine manages transaction processing, a new
session of the Jet database engine contains its own transaction
management. The two are mutually exclusive; transactions in one are not
managed or affected by transactions in the other.
The simplest workaround for this problem is the QueryDef.Execute
method, which uses a recordset.
NOTE: The QueryDef.Execute method works only when a QueryDef action is
based on an action query (update, insert, delete) that does not return
a recordset.
Additional query words:
commit record set
Keywords : kbusage McrActn
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbinfo