I am using Datasheet view when displaying my data.
The data are displayed in a "x,y" matrix wherein data can be directly edited
in the Datasheet.
Anything inputted in a certain cell is directly updated to DB.
I want to open the Form, input data but WILL NOT COMMIT then close the Form.
If I open the same Form again, the data shouldn't be changed because it wasn't committed.
What I did was declare a global Workspace:
Expand|Select|Wrap|Line Numbers
- Public WS As DAO.Workspace
Expand|Select|Wrap|Line Numbers
- Set WS = DBEngine.Workspaces(0)
I started the db transaction setting:
Expand|Select|Wrap|Line Numbers
- WS.BeginTrans
For testing purposes, in my Close button click event, I made a rollback setting:
Expand|Select|Wrap|Line Numbers
- WS.Rollback
But when I opened that Form again, the data was not rolled back to its old value.
What's wrong with this?
Aren't these BeginTrans, CommitTrans and Rollback work well with Datasheet?
Calling all Access Gurus...I badly need help.
-= keirnus =-