Write Conflict

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi guys,

I am getting a write conflict error, “This records has been changed by
another user since you started editing it…..,†I don’t know how because I am
the only one using the program, I use rs.Edit and rs.Update to modify the
table fields, the error occurs when I am closing the form.

I’ll really appreciated any help.

Thanks
 
I think it's probably the rs.Edit. Access sees that the record has changed,
but since it was your code and not the form itself that made the change, it
sees the change as from "another user", meaning not the form. Try making
your edits by updating the values of form controls instead of with rs.Edit.
 
Yes, that is the problem, I eliminated one of the rs.Edit .....rs.update and
the problem was solved.
 
Back
Top