Write Conflict

Hello,
I have an Access03 FE with a MySQL BE. I am getting a "Write Conflict" message after 'viewing' a form. This happens when the form is closed although no data was changed. (Using a DoCmd.Close statement with Save property set to NO "acSaveNo".)

I looked through related threads and have added a TimeStamp to the MySQL table, but it still does not relieve the issue. Any ideas on what is causing this and how I can prevent the message from popping up?

Thanks,

Scot

Do you have other forms that work fine and it's only this one that gives the error or do you only have one form?

If you just have the one form, I'd try creating a new simple form that just hits a few fields of one table and see if it gives you the same error.

This happens on different forms. The issue as I see it is that, when I view the data and then move my view to another form. Access wants to update the data, even if nothing has changed. It is at this point I receive the error message. If I could just get Access to release the data when there are no changes. Obviously, something has changed, or the way the data is handled is just different.

~Scot