• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

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.

1 Solution
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:

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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now