Problem connecting to a MS Access database in QlikView


I'm new to QlikView and Access databases and have hit a problem when trying to connect to the Northwind.mdb practice database.

The error returned is....

"SQL##f - SqlState: IM003, ErrorCode: 160, ErrorMsg: Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Access Driver (*.mdb, *.accdb), C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEODBC.DLL).

Does anyone have an idea how I may resolve this problem ?

Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
And the makers of QlikView  have no info on this?

I am seeing lots of links for this issue in a basic web search:

Just be aware that not everyone may be familiar with this one product.
So, can you explain, in detail, how you are trying to connect QlikView  to your Access database?

Also note that there are about 3 different versions of the Northwind sample database. So you need to tell us where you are getting your copy from
(there may be differences in connecting to the .mdb version and the.accdb version.)

TocogroupAuthor Commented:
Thanks for the link Jeff.
I found the issue -  it appears I was trying to connect to Access DB from a 64 bit machine. There is a checkbox in QlikView to specify a 32-bit ODBC data source for your MS Access database.
Works fine.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.