Write Conflict Message when using a Form

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I'm entering data on a Form and occasionally a Write
Conflict message shows up saying "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 used made. Copying the changes to the clipboard
will let you look at the values the other user entered,
and then paste your changes back if you decide to make
changes."

The data in some fields in the underlying record becomes
completely corrupted.

Since I'm the only "user", I'm completely lost about this
write conflict. Any ideas?? Thanks for your input.
 
You likely have some code that runs a process that updates the tables.
ms-access can't tell the difference between your code, or some other user
out there that changed the data.

So, the solution is to WRITE you data to disk BEFORE you run any code or
update quires on the data.

You can place the follow line of code to write the data *before* you run any
other update code

me.Refresh
 
Back
Top