Looking at Transaction Processing Issues
Before you decide that transaction processing is the best thing since sliced bread, you should keep in mind several issues concerning transaction processing. This section outlines these issues.
Realizing That Transactions Occur in a Workspace
Transactions exist in the context of a Connection object. The BeginTrans, CommitTrans, and RollbackTrans methods affect all operations on the specific connection. If you want simultaneous, unrelated transactions to be in effect, you must create separate Connection objects in which the transactions are applied. Whereas data access objects (DAO) supported transactions that spanned multiple databases, ADO transactions are limited to a specific data source because they ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.