ODBC Data Sources; can't add MySQL Driver

Question

I want to connect MS Access with MySQL. I installed Xampp for MySQL and now I installed the ODBC driver 5.3. I went to Data Sources and clicked on System-DSN to add the MySQL ODBC 5.3 Driver (like shown in this video https://www.youtube.com/watch?v=F06hvR6ksh4). But there wasn't any MySQL ODBC 5.3 Driver. My OS is Windows 7 Home x64. How can I connect the ODBC Driver to the MySQL Server?

Answer 1

If you try to use 32bit MySQL ODBC connector on 64bit Windows, you need to use 32bit Data Sources (c:\Windows\SysWOW64\odbcad32.exe).