Write Conflict

[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

 

[ruralguy via AccessMonster.com]

Try using a query of the table instead of the table directly as the
RecordSource of the form.

 

[Paul Shapiro]

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.

 

[Maracay]

Yes, that is the problem, I eliminated one of the rs.Edit .....rs.update and
the problem was solved.