|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