I migrated my Access tables to MySQL hosted server and linked the tables back to MS Access front-end and now I cannot edit the records in my forms. I can see the data and go between records, but I cannot edit data at all. Cannot select other values from drop down, or even modify a misspelling. Can anyone help me with this issue?

  • Do you get any errors? – Lennart Dec 27 '19 at 22:57
  • No errors at all. – Alex Dec 27 '19 at 22:58
  • Can you use a tool like MySQL Workbench? p.s. welcome to the forum! :-) – Vérace Dec 28 '19 at 12:48
  • Thanks. I have used MySQL Workbench, but I don't what I should do there to fix my problem. Can you advise what I should do? – Alex Dec 28 '19 at 23:13
  • Read the docs and dev.mysql.com/doc/connector-odbc/en/…. Provide necessary infos (odbc connection config, version infos for db and connector, office version) User has sufficent priviliges to edit data (try in workbench from same client) – ComputerVersteher Dec 31 '19 at 8:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.