BeginTrans, CommitTrans, Rollback Methods
BeginTransbegins a new transaction .
CommitTransends the current transaction.
Rollbackends the current transaction and restores the database to the state it was in when the current transaction began.
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.