WinSQL » Knowledge base

Document information

Document ID:756
Subject:Transactions in MS Access
Creation date:7/29/09 11:42 AM
Last modified on:7/29/09 11:42 AM


Details


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

Auto commit mode

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.

Commit and rollback




User comments

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.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com