ODBC Access Driver

I have a 64-bit Windows Server 2008 R2 box that I need to install Access drivers so that when I create a new ODBC system DSN, I can choose "Access" and connect to an Access database.

The Access database will built using 32-bit Access.  Not even sure if there is a 64-bit version.

I need to enable my 32-bit application on this machine to connect to Access data.  Not sure what I'm doing wrong or not doing.  I've installed what I thought would be the right things, but nothing.  Installed MDAC 2.8 most recently.  Nothing.

What am I missing?  When I go to create a new DSN, my only options are for SQL.  No Access databases.

Thanks.
bamapieAsked:
Who is Participating?
 
dqmqConnect With a Mentor Commented:
There is no 64 bit driver for Access.  To "see" the 32-bit driver, you need to use the 32-bit admin tool.  Try:  c:\windows\sysWOW64\odbcad32.exe

Or perhaps this:
http://support.microsoft.com/kb/942976

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.