Write Conflict

Hey All,

The tables in my database are linked to a server. Everytime I try to edit an existing record, I get a box that says,

"write conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwritethe 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."

and it provides me three choices, Save Record, Copy to Clipboard, Drop Changes. The Save Record option is grayed out and I am not able to select it. I am the only user accessing these tables so there should be not sharing conflicts. Any help with this would be greatly appreciated! Thanks!

shwin,
I was just dealing w/ this problem. The issue is that Access pulls information from the MySQL server and then saves it before it inserts your changes. Before it inserts your changes it compares what it had initially against what is currently in the MySQL server. There are some problems w/ this comparrison having to do with floating point/double and dates that results in a failed comparison. So Access thinks someone else has changed the data.

The solution was rather simple, however. To you table in MySQL add a column of type "TIMESTAMP" and I think even name it "timestamp". This is the same type of field Access uses to interact with SQLServer so it knows what to do with it. Instead of comparing all this data back and forth it just checks this timestamp entry and ignores the rest.

That fixed my problem anyway.

Good luck
-Nic

Thanks Nic! I appreciate your help!