write conflict

[bakerboy_1111]

Hello All,

I've created a query that resets a table entry called "Drum" to null if I change the record "Cable". This process works, except I get the following error when I do so:

" Write Conflict

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.

[Save Record] [Copy to Clipboard] [Drop Changes] "

I have set warnings to false but this still comes up.

Does this mean something is wrong with my method of updating the table? If not, is there any way I can stop the warning coming up?

Thanks to anyone who helps,

Bakerboy

 

[CustomCode]

Hello All,

I've created a query that resets a table entry called "Drum" to null if I change the record "Cable". This process works, except I get the following error when I do so:

" Write Conflict

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.

[Save Record] [Copy to Clipboard] [Drop Changes] "

I have set warnings to false but this still comes up.

Does this mean something is wrong with my method of updating the table? If not, is there any way I can stop the warning coming up?

Thanks to anyone who helps,

Bakerboy

use me.refresh

Make sure me.refresh occurs before you run the query

You are getting the write conflict because the record is locked. While the record is locked you are now trying to make another change the record with a query. The query is treated by access like it is a different user.

Hope this helps