Microsoft Access 64-bit - ODBC driver

Latest update on by Jean-François Pillou .

To install and configure the ODBC driver for Microsoft Access Office Software, you have to download the 64-bit ODBC driver from the ftp files directory of the IBM Websphere database. Download the driver list on to a temporary directory. Now, give the command tar -xvf file_name.tar to untar the files and then placefile_name.tar in the nameof the file selected before as the ftp file. After running the script/setup commands, there are some prompts to follow as to complete the ODBC driver installation. Lastly, you must configure the odbc.ini file. Once the ODBC Driver is installed, edit the system information file, name it odbc.ini, and set or modify the attributes of this file as required.

Issue

I am having problems with ODBC when using Java to access a database in Microsoft Access on a system running Windows 7 Professional (64-bit). I am looking for a 64-bit ODBC driver in the hope that it will solve my problem.

Solution

The utility found here should help you fix this problem:

c:\windows\syswow64\odbcad32.exe

Alternatively:

  • In Project Properties, go to Compiler
  • Click Advanced compilation
  • Change "Unit ventral target" and choose "x86"
  • Recompile

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « Microsoft Access 64-bit - ODBC driver », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).