After wasting 3+ hours trying to set up linked tables in MSACCESS 2010 to MySQL tables through ODBC, I finally stumbled upon a solution that worked:
http://qt-project.org/forums/viewthread/23532 - basically, the answer is DO NOT download the 64bit driver (even if you have a 64 bit system). Once you have the 32bit driver installed, set up the MySQL database as a SYSTEM dsn (and not a USER dsn). Thank you Luca!
http://qt-project.org/forums/viewthread/23532 - basically, the answer is DO NOT download the 64bit driver (even if you have a 64 bit system). Once you have the 32bit driver installed, set up the MySQL database as a SYSTEM dsn (and not a USER dsn). Thank you Luca!