|Subject:||Transactions in MS Access|
|Creation date:||7/29/09 11:42 AM|
|Last modified on:||7/29/09 11:42 AM|
Although MS Access support transactions, there is no SQL statement
to manage them. Instead, Access uses VBA code to manage transaction.
This is done automatically for you in WinSQL if you open the connection in "Manual Transaction mode". Refer to the image below
In this mode you see a red indicator in the status bar and any DML
statement that you run is enclosed within a transaction. To rollback or
commit, click the right mouse button in the query tab and select the
appropriate value. Refer to the following image for a screen shot.
Posted by Yawar on 2/10/13 1:00 PM
You can use BEGIN TRANSACTION, ROLLBACK TRANSACTION, and COMMIT TRANSACTION in your SQL queries in Access 2007+ (at least). See http://msdn.microsoft.com/en-us/library/office/bb208950%28v=office.12%29.aspx
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.