O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

INCREASING SPEED WITH TRANSACTIONS

In the CopyData subroutine in Listing 5.10, notice the wspTransact.BeginTrans line. Access supports transactions, which, in some cases, greatly increase the speed of modifying and updating data. By using a transaction, you can group a large number of updates into a single operation.

However, transactions are more than just faster updates. By using transactions, you can modify one or many tables. At any point during the update, you can decide to cancel, or roll back, the transaction. Rolling back a transaction causes no updates to be saved to your database.

Note

If you plan to use transactions for performance purposes, be sure to run benchmarks with and without the transaction commands. In prior versions of Jet ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required