CODEWITHSUNDEEP
javams-accessodbc
London Student
London Student

Reputation: 915

ODBC driver for MS Access seems missing (Windows 64 bit)

I am simply trying to connect a java application to MS Access in the Eclipse IDE. From what I have read and done on other computers I need to go to the ODBC Data source administrator and add user DSN MS Access Database. The problem I have is that I recieve an error indicating that the ODBC Driver is not installed.

Now I assumed it would be as simple as downloading and installing it like say MySQL ODBC driver, this doesnt seem to be the case. From what I have read it is somthing to do with 32 and 64 bit windows 7 o.s.

I would appreciate if someone could identify the problem.

Thanks in advance

S

Upvotes: 3

Views: 13195

Answers (3)

sherz
sherz

Reputation: 19

its late but maybe good for someone in future you can download form here https://www.microsoft.com/en-us/download/details.aspx?id=54920 64 bit or 32 according to your needs

Upvotes: 0

nick
nick

Reputation: 630

solution found on this website: https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing

It's likely the shortcut for setting ODBC data sources is pointing to the 32bit data sources instead of 64bit.

Go to control panel -> administrative tools --> select data sources(ODBC) --> then right click on that file --> go to properties --> in the shortcut tab -> change the path from %windir%\System32\odbcad32.exe to

%windir%\SysWOW64\odbcad32.exe

and make your connection. the driver for MS Access will work fine now.

Upvotes: 0

Smandoli
Smandoli

Reputation: 7019

Could this help?

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb

Upvotes: 2

Related Questions