Import Error from MySQL (-7745)

[Ant_Snell]

I have split my DB to a MySQL Backend, it has exported the tables fine but lost all the primary & Foreign Keys. When I re assign them using the MySQL Workbench and try to link them back to my Access front end using the ODBC connection I get a “Reserved error (-7745);there is no message for this error” error. If I don’t create the primary & foreign keys first it imports fine as a link however I want the relationships to be server side because other apps will also access the tables. My ODBC drivers are 8.1.0 win64 which I believe to be the latest available.
Any ideas of how to fix this or a workaround would be much appreciated. ( I have not used MySQL before so a complete novice with this).

[isladogs]

See my article Reserved Error - There is No Message for this Error (isladogs.co.uk) which discusses several reserved errors including this one.
Apparently you need to replace version 8.1.0 driver with the earlier 8.0 and I'm told the problem will be fixed

[Ant_Snell]

isladogs. Fantastic! First time! Thank you for your help, that has saved me hours of head scratching.

[isladogs]

You're welcome. If its not too late (i.e. if its not already fixed), are you able to email me with any additional info or screenshots on the error for possible inclusion in my article.
You can find my email in the signature line below