I am using Access 2007 on a Windows 7 64 bit pc.
I have a table linked to a MySQL database on my website.
I am using the mysql-connector-odbc-5.1.8-winx64 to connect to the database.
I am able to make the connection and see the values.
If I try to make a change I get the following error:
This record bas 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 not available
Copy to Clipboard and Drop Changes are available
This was working until recently.
I can connect to the MySQL table and make changes from a copy of the database running on a XP computer and a copy running on Server 2003. No problems.
I also created a new database with the only object being the linked table. Same problem.