Microsoft Access Driver (*.mdb) ODBC driver

I wrote an article earlier on how to connect ms access to java. So this article is continuity in solving major issues beginners may or can face. I wrote on solving ODBC connection problem in my previous article and I wish to continue and then give a sample code on connecting to ms access with java.

The two possible errors you get from Data Source (ODBC) from control panel are:

  • The specified DSN contains an architure mismatch between the driver and Application.
  • The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be found.

 

To solve this problem of ODBC not connecting to Microsoft access driver follow these steps:

i) Go to control panel and click on administrative tools and on your next window right click on Data Source (ODBC) and click on properties. Then on your shortcut tab change these following to new ones.

Old target: %windir%\system32\odbcad32.exe

Old startin: %windir%\system32

Type in this new ones:

New target: %windir%\SysWOW64\odbcad32.exe

New startin: %windir%\ SysWOW64

 

ii) Save your settings and double click on Data Source (ODBC), after just click on your User DSN and click on Add button and follow the instruction on how to select your MS access. Do the same with System DSN and definitely you will get connected.

 

Please note:

For some reasons you may have to uninstall the 32 bit engine and / or 32 bit Office because you can’t have 32 bit Office products and components installed with 64 bit Office products and components. The reason being that Jet is being deprecated but it is still included with Windows, it is just found in the SysWow64 folder on 64 bit machines and is still only a 32 bit component.

 

I hope this article solve your microsoft access odbc driver issues and Microsoft database engine 2007 access driver connection. Please ask any question by emailing me or contact me via our online contact form.

Recommended: The step by step of how to use access database with Java

data-matched-content-rows-num="2" data-matched-content-columns-num="2" data-matched-content-ui-type="image_stacked"

Leave a Reply

Your email address will not be published. Required fields are marked *