MS Access - Keeping track (transacation) of all activity while form is open...
Posted
by Ron Mac
on Stack Overflow
See other posts from Stack Overflow
or by Ron Mac
Published on 2010-04-06T15:29:18Z
Indexed on
2010/04/10
8:33 UTC
Read the original article
Hit count: 235
ms-access
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.
© Stack Overflow or respective owner