Problems with Access as front to MySQL

[nic33]

I'm having the following error pop-up whenever a user tries to enter information into a form that is linked to a table in my MySQL database:

"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 form worked fine when I simply exported the table from Access to the MySQL server through the MyODBC driver, but when I edited the table from MySQL (I had to add a column) and relinked it to my Access program this message started popping up. All that MySQL support says is to make sure "Return Matching Rows" is checked in my MyODBC settings, and it is.

So I'm hoping someone here might have some more ideas.
Thanks for your time.
-Nic

 

[nic33]

Nevermind,

All that was needed is to add a field of type "TimeStamp" to the table, that way access doesn't have to compare all the values it had initially against the ones it re-pulls from the server to check for consistency. Apparently there can be some problems when comparing dates and numbers this way and so Access thinks the data has changed when it really has not.