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).