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

Written By
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.