Connecting MS Access to Mysql

[amc]

I am trying to test MSAccess (2013) as a front end and Mysql as a backend.

I am on windows 10, using Xampp.

The odbc connection test works (from Administrative Tools, 64 bit ODBC), but when trying to link tables from Access it crashes with a very basic message:

ODBC Call failed: Microsoft ODBC manager, the chosen DSN architecture doesn't match between controller and application (#0)

I might have done something wrong, but don't know what.
thanks

 

[Tieval]

Have you checked your Access version as it will not match 32 bit Access to 64 bit ODBC controller, the mention of architecture normally refers to a mis-match between 32 and 64 bit parts.

 

[amc]

Ooops!, My Access is 32bit

But, then, how can I create the connection? I don't see any driver for ODBC 32 bit (except one for Oracle)

thanks