Problem connecting to a MS Access database in QlikView

Hi,

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 ?

Thanks
Toco
TocogroupAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS 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:
https://www.google.com/#q=%22QlikView%22++%22microsoft+Access%22&safe=off

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

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
Regards
Toco
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.