TRANSACTION Statement (Microsoft Access SQL)
Used to initiate and conclude explicit transactions.
Transactions are not started automatically. To start a transaction, you must do so explicitly using BEGIN TRANSACTION.
Transactions can be nested up to five levels deep. To start a nested transaction, use BEGIN TRANSACTION within the context of an existing transaction.
Transactions are not supported for linked tables.