Why am I getting the "Write Conflict" error message?

[Nicole]

I've researched other threads concerning the Write Conflict error, however
those issues seem to be more complicated than mine.

When updating a record (and I know that I'm the only one updating this
record), after trying to move on to another function or save the record, I
get a Write Conflict message with the following contents:

"This record has been changed by another user since you started editing it.
If you save the record, you will overwrite the changes the other user made..."

Why is this happening when I know no other users are updating a record only
I should be updating?

 

[Ken Snell \(MVP\)]

That error message means that you, somehow, are trying to edit the same
record more than once at the same time. It could be because you have more
than one form open that is bound to that table and is displaying the same
record, or a subform that is bound to that table and showing that same
record, or....

This can be a complicated error to track down, but you can be assured that
the error is occurring because, somehow, your database design is letting you
try to edit the same record more than once at the same time.

 

[Nicole]

Ken:

Could it be because my database was on the brink of corruption? 20 minutes
after posting this question it all hit the fan. Could the explanation that
you provided be a reason that the corruption occurred?

In any case, I'm now working on the recovery and am hoping that once I do
recover the Write Conflict will not occur again. Thanks.

Nicole

 

[Ken Snell \(MVP\)]

That is certainly possible -- it's also possible that the write conflict
caused the corruption.