ODBC connection failure between Access frontend database and MySQL
A new Windows laptop has 64 bit Connector/ODBC 8.4.0 installed, using the same procedure for other computers in the same company. When I open a linked table I get the rather unhelpful message ODBC call failed. No error number. I am using User DSN and have not changed any settings in the Details section, the only boxed ticked is the “Disable schema support” on the Metadata tab.