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.
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.