J
Julia Boswell
All,
I have a form with an action button which has quite a bit of code behind it.
It performs some validation, then if validation passes, several recordsets
are updated with mulitiple data (different depending on conditions), using
ADO.
The code is compiled and has been thoroughly tested and found to work
(famous last words!), however I've had some recent incidences where a user
has entered multiple data and only some of the recordsets have updated.
Through searching this forum I've found that I need to use BeginTrans,
CommitTrans and Rollback to improve my code, but I still don't know what the
cause could be.
Can anyone think of anything that could cause a problem like this? Currently
the only suspision I have, is that my user tells me that the code works fine
if he keeps Access open. He believes that the 2 occasions where things have
gone wrong are when he has switched to other programmes after pressing the
action button. Should this make any difference?
Thanks in advance.
Julia
I have a form with an action button which has quite a bit of code behind it.
It performs some validation, then if validation passes, several recordsets
are updated with mulitiple data (different depending on conditions), using
ADO.
The code is compiled and has been thoroughly tested and found to work
(famous last words!), however I've had some recent incidences where a user
has entered multiple data and only some of the recordsets have updated.
Through searching this forum I've found that I need to use BeginTrans,
CommitTrans and Rollback to improve my code, but I still don't know what the
cause could be.
Can anyone think of anything that could cause a problem like this? Currently
the only suspision I have, is that my user tells me that the code works fine
if he keeps Access open. He believes that the 2 occasions where things have
gone wrong are when he has switched to other programmes after pressing the
action button. Should this make any difference?
Thanks in advance.
Julia