Alison Balter's Mastering Access 2002 Enterprise Development

Implementing Explicit Transaction Processing

Now that you are aware of the settings that affect transaction processing, you are ready to learn how to implement transaction processing. Three methods of the Connection object (covered in Alison Balter's Mastering Access 2002 Desktop Development) control transaction processing:

• BeginTrans

• CommitTrans

• RollbackTrans

The BeginTrans method of the Connection object begins the transaction loop. The moment the code encounters BeginTrans, Access begins writing all changes to a log file in memory. Unless you issue the CommitTrans method on the Connection object, Access never actually writes the changes to the database file. When you issue the CommitTrans method, Access permanently writes the updates to the ...