Nesting Transactions

In Microsoft Jet workspaces, you can have up to five levels of transactions active at any one time by nesting combinations of the BeginTrans and CommitTrans methods or the Rollback method. If you nest transactions, you must make sure you commit or roll back the current transaction before trying to commit or roll back a transaction at a higher level of nesting.

If you want to have additional levels of nesting, or want to have transactions with overlapping, non-nested scopes, you can open additional Workspace objects and manage other transactions within those new workspaces.