Problems connecting to ODBC

[jacqueshol]

Hi All,

I, as a novice, would appreciate some assistance.  I have a small Microsoft Access database that I want to connect to in QlikView 11.2 SR8.

However whenever I create a new QlikView file, select Edit Script, ODBC as my Database and click Connect, I get the following error:

I have tried connecting to the Access database from another machine and got the same error.  Obviously some setup is missing, but I can figure out a solution.  I thought perhaps my Microsoft Access is installed incorrectly, but I am able to open the Access database and edit as needed.  Just can't connect to the database in QlikView.  Any help would be greatly appreciated.

Thanks,

Jacques

[beck_bakytbek]

Hi Jacques,

if you need the same way of proceeding for MDB.Format.

just let me know

beck

[jacqueshol]

Hi Beck,

I would appreciate that.  It would be nice to be able to connect to the MDB format too.

Thank you for assisting. Much appreciated!

Take care,

Jacques

[beck_bakytbek]

Hi Jacques:

here is a way of proceeding in case of : MDB.Format

step1: Select "OLE DB" in the Database tab

step2: Check "force 32 bit"

step3: Click "Connect"

step4: in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"

step5: Click "Next"

step6: You will be directed to "Connection" tab

step7: Select the Database in 2002 Format(.mdb)

step8: Go to "Advanced" tab, uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection" tab and click "Test Connection"

step10: You will have message: like "Test Connection succeeded"

step11: Click "Ok"

beck

[jacqueshol]

Hi Beck,

Thanks a mill, once again!  Truly appreciate the wonderful help I got.

Take care,

Jacques