title | TOCTitle | ms:assetid | ms:mtpsurl | ms:contentKeyID | ms.date | mtps_version | f1_keywords | f1_categories | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|---|---|---|
TRANSACTION statement (Microsoft Access SQL) |
TRANSACTION statement (Microsoft Access SQL) |
481e807d-94e4-f201-adac-d25ee89d9220 |
48544614 |
10/18/2018 |
v=office.15 |
|
|
high |
Applies to: Access 2013, Office 2013
Used to initiate and conclude explicit transactions.
Initiate a new transaction:
BEGIN TRANSACTION
Conclude a transaction by committing all work performed during the transaction:
COMMIT [TRANSACTION | WORK]
Conclude a transaction by rolling back all work performed during the transaction:
ROLLBACK [TRANSACTION | WORK]
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.