Microsoft Access 64-bit - ODBC driver

January 2017

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

Related


Published by aakai1056. Latest update on November 4, 2012 at 05:55 PM by Jeff.
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).