Update to Mysql 5.7 causes insert failed error
I recently upgraded from Mysql 5.6 to 5.7 on our server. We are using MS Access 2010 front end with ODBC Connection to the mysql database. We can edit records in a table but not create a new one. When we try to save a new record in a table it gives the error ODBC--Insert table failed. I have ODBC 8.0. Other tables in the database will allow new records. It's just our main work horse table..... ov course! I have tried to repair the database but it didnt help. Suggestions?
Subject
Written By
Posted
Update to Mysql 5.7 causes insert failed error
October 13, 2020 04:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.