MS Access - Keeping track (transacation) of all activity while form is open...
- by Ron Mac
Hi and thanks for reading. I am not a database/vba guy and my experience is strictly in the JAVA world. However, I need to have an ACCESS form open. While it is open and new data is entered into it (via the underlying query OR any other data changes in other tables based on sql updates attached to buttons on this form), is there a way that I can initiate a transaction so that at the bottom of the form I could have a button that says "Exit and committ changes" or "Cancel and Rollback changes".
I guess I thought of a situation where I could do something like:
On Form OPEN, START TRANSACTION
On "CLICK OK", COMMIT TRANSACTION or ON "CLICK CANCEL" ROLLBACK.
I'm aware how to do the Workspace.BeginTransaction but I'm not sure if that will apply if I do it on FORM OPEN and then on FORM CLOSE do the COMMIT/ROLLBACK locgin?
Any insight would be great.