<div>
<div class="content wysiwyg-content">
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 &quot;Access&quot; and connect to an Access database.<br />
<br />
The Access database will built using 32-bit Access. &nbsp;Not even sure if there is a 64-bit version.<br />
<br />
I need to enable my 32-bit application on this machine to connect to Access data. &nbsp;Not sure what I'm doing wrong or not doing. &nbsp;I've installed what I thought would be the right things, but nothing. &nbsp;Installed MDAC 2.8 most recently. &nbsp;Nothing.<br />
<br />
What am I missing? &nbsp;When I go to create a new DSN, my only options are for SQL. &nbsp;No Access databases.<br />
<br />
Thanks.
</div>
</div>


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.

ODBC Access Driver

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.