access error when saving a record thats been modified

[shawn bright]

Hey all,

I am using microsoft access as a front end to the MySQL database that runs the website. I am using MyISAM tables. Sometimes, especially after a period of inactivity, a table row that i am viewing may have been changed by another process. When that is the case, i am given an error when i try to make a change.
It gives me an option of copying the changes to the clipboard so i can see them then. But does this just reflect what i have changed? or does it effect every value in the row.

Perhaps a better question, is there a better way to connect than with the ODBC or an engine better than MyISAM for this sort of thing?
thanks for any tips.