Connecting to MySQL db through ODBC in Access 2010

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?
figsageeAsked:
Who is Participating?
 
danishaniConnect With a Mentor Commented:
That's seems like the way to accomplish it.

Check also below thread, with more detailed steps:
http://www.ajpdsoft.com/modules.php?traducir=es-en&name=News&file=article&sid=573

Hope this helps,
Daniel
0
 
danishaniCommented:
0
 
figsageeAuthor Commented:
I did try that. I would use odbcad32.exe to create the data source, right? I got stuck because I didn't see the MySQL driver on the list of options when I ran odbcad32.exe.
0
 
figsageeAuthor Commented:
That worked! I had to reinstall the MySQL ODBC driver using the instructions at the link you gave. It seemed to be exactly the same way I installed the first time, except I clicked on Custom for installation options. But I didn't change anything! Anyway, after I did that I was able to see the MySQL driver when I ran odbcad32.exe.

Thank you!
0
 
figsageeAuthor Commented:
Thank you, Daniel!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.