
error using recordset.edit method (3197)
I am getting the error 3197: "You and another user are attempting to change
the same data at the same time." when I try to use the recordset.edit
method.
There is one user running the application.
I do NOT get the error if I start the application from scratch and procede
directly to the form which is causing the problem.
I do get the error if I first try to run a few tasks then run the form which
is causing the problem.
I have tried to locate any problems in my code such as opening recordsets
and not closing them. But so far I have not found any. (doesn't mean that
they don't exist, though)
Has anyone had a prior experience with this error and how was it resolved?
Thanks ahead of time,
David Howlett
Amulet Consulting