Write Conflict Error

[Guest]

Hi

I am randomly getting a default Access Mgbox that says the following..

"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

Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

Followed by 3 buttons..
"Save Record" "Copy to the clipboard" "Drop Changed

I have no idea why I am getting this. I am the only user using it, & it comes up at random when I move around in a Sub-Form.

Is their anyway to turn this off ? Any way to Trap this error ? Any way to stop this from happeneing

I tried going into Tools / Options / Advancded & chaged the "Default Record Locking" to all 3 values it doesnt make a difference

Any Help would be greatly appreciated

Thank you
Jef
(e-mail address removed)

 

[Albert D. Kallal]

In your case, that message usually means that some of your code modified the
record.

So, in concept..that "other user" is in fact some code.

The solution to this problem is to make sure the form writes it data to disk
BEFORE you run any code that can execute sql/commands to update the same
data.

So, in your code go:

me.refresh

You update code goes here....