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.