MySQL Forums
Forum List  »  Connector/ODBC

Update to Mysql 5.7 causes insert failed error
Posted by: karen turchyn
Date: October 13, 2020 04:26PM

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?

Options: ReplyQuote


Subject
Written By
Posted
Update to Mysql 5.7 causes insert failed error
October 13, 2020 04:26PM


Sorry, only registered users may post in this forum.

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.