Write conflict

[IanF]

I get the following error when updating the date field on
a form:

"Write conflict: The 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"

There is no other user, it occurs in a process where I
import data and once imported, the form updates the date,
rows imported and indicates success. If I import again
after this and change the date, I get the above write
conflict.

How do I get around this?

Thks in advance

IanF

 

[Michel Walsh]

Hi,


VBA code modifying data is a different user (for the database) than the
one in front of the keyboard... both may try to update the same record at
the same time, after all. Isn't it your case? Is you VBA code trying to
update the ACTUALY displayed record? is it dirty? if so, you have your
conflict... solve it pacifically, make a

Me.Dirty = False

to save the record, or

Me.Undo

to undo any modification to the record

as appropriate, if Me.Dirty is actually true, before running the VBA
process.


Hoping it may help,
Vanderghast, Access MVP