Menu

Microsoft Access 64-bit - ODBC driver

USFR
Ask a question
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

Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Related