![ms access drivers ms access drivers](https://www.stata.com/support/faqs/data-management/configuring-odbc-win-legacy/8.1user2.png)
Install the 64-bit Windows ODBC-ODBC Bridge distribution.Īccept the Default option during Setup, which will install both the ODBC-ODBC Bridge Client and Server components.Note The 32-bit ODBC Data Source Administrator is not accessible from Windows Control Panel. To access the 32-bit ODBC Data Source Administrator, run the following command in the Windows Run dialog box: %windir%\syswow64\odbcad32.exe
![ms access drivers ms access drivers](https://www.techonthenet.com/access/tutorials/passthrough/images/basics02_004.png)
In the 32-bit ODBC Data Source Administrator, configure a System data source for the Access ODBC driver.The application used is the SQL Server Integration Services (SSIS) Import and Export Wizard. The ODBC driver used is the Microsoft Access ODBC driver.
#MS ACCESS DRIVERS HOW TO#
The following steps show how to access a 32-bit ODBC driver from a 64-bit application on a 64-bit Windows machine. Example: How to Connect a 64-bit Application to a 32-bit ODBC Driver ODBC calls made by your 64-bit application are passed from the 64-bit ODBC driver (the ODBC-ODBC Bridge Client) to the target 32-bit ODBC driver via the 32-bit ODBC-ODBC Bridge Server. To connect a 64-bit application with a 32-bit ODBC driver, you use a 64-bit ODBC-ODBC Bridge Client and a 32-bit ODBC-ODBC Bridge Server. For example, a Linux ODBC-ODBC Bridge Client and a Windows ODBC-ODBC Bridge Server.) (The RPC mechanism also allows a ODBC-ODBC Bridge Client for one platform to be used with a ODBC-ODBC Bridge Server for a different platform. A 64-bit ODBC-ODBC Bridge Client can be used with a 32-bit ODBC-ODBC Bridge Server and vice versa. The ODBC-ODBC Bridge Client communicates with the ODBC-ODBC Bridge Server by using the Remote Procedure Call (RPC) mechanism. The ODBC-ODBC Bridge Client is not linked against the ODBC-ODBC Bridge Server. The ODBC-ODBC Bridge is a client/server product. For example, Microsoft’s Access ODBC driver. For some ODBC drivers, only a 32-bit version is available. 64-bit ODBC Driver Managers can only load 64-ODBC drivers. For this reason, 64-bit applications can only link against a 64-bit ODBC Driver Manager library. 64-bit applications must be linked against 64-bit libraries. Without the ODBC-ODBC Bridge, a 64-bit application cannot connect to a 32-bit ODBC driver. Yes, you can connect a 64-bit application to a 32-bit ODBC driver by using the ODBC-ODBC Bridge.