O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Transactions

Microsoft Access allows you to combine several database operations in a single transaction. The changes to the database are only valid when all suboperations for a transaction have been processed successfully. If this is not the case, then the database is returned to its original status before the transaction was commenced.

The basic rules for processing of transactions can be described with the acronym ACID:

  • Atomicity means that a transaction cannot be subdivided further; it represents the smallest possible unit.

  • Consistency means that the system must always have a consistent status after a transaction has been completed.

  • Isolation means that different transactions running simultaneously are not allowed to interfere with one another. ...

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