BeginTrans, CommitTrans, Rollback Methods

See AlsovbmthBeginTransSee

Description

         BeginTransbegins a new transactionAGBRTK.

         CommitTransends the current transaction.

         Rollbackends the current transaction and restores the database to the state it was in when the current transaction began.

Syntax

database.BeginTrans

database.CommitTrans

database.Rollback

Remarks

These methods are included only for compatibility with an earlier version of Visual Basic and are not recommended.  The corresponding statements have exactly the same effect, are compatible with Microsoft Access Basic, and make your code easier to understand.

Caution   Whether you use one of these methods or their corresponding statements, the effect is the same.  Transactions are always global and never limited to only one database or recordset.  If you include operations on more than one database or recordset within a transaction, Rollback restores all operations on all databases.