Connecting to MySQL db through ODBC in Access 2010
Posted on 2012-03-29
I used MySQL ODBC 5.1 driver to create a System data source. I tested and all was successful, and the data source shows up in ODBC Data Source Administrator under System DSN. (Actually, I've tried it several times so I should say that all the data sources I've created are listed in ODBC Data Source Administrator under System DSN.)
I want to connect to the data source through Access 2010, but when I get to the list of Machine Data Sources in Access, none of the data sources I created are on the list.
A friend who is helping me did exactly the same thing on his laptop and the data source was in the list when he went to connect.
My machine is Windows 7 64 bit.
Any ideas what might be happening?