topic Re: ms access connection failure in QlikView

Qlikview

Anonymous — Wed, 27 Jul 2016 14:50:56 GMT

Hi all,

Requesting your suggestion on the following error:

please suggest me

Anonymous — Wed, 27 Jul 2016 15:07:34 GMT

any suggestion please

beck_bakytbek — Wed, 27 Jul 2016 15:10:25 GMT

Hi John,

what Kind of MS Access are you using? MDB OR ACCDB

if you use MDB;

step 1: "SELECT OLE DB" in the Database Tab

step 2: "Check force 32 bit"

step 3: Click "Connect"

step 4: in data link properties: "SELECT "Microsoft Jet 4.0 OLE DB Provider"

step 5: Click "Next"

step 6: You will have / directed to "Connection tab"

step 7: Select the Database in 2002 Format (.mdb format)

step 8: Go to Advanced tab; uncheck "Share Deny None" & Check "Read/Write"

step 9: Go to "Connection tab" and click "Test Conection"

step 10: you have then message "TEST CONNECTION succeeded"

step 11: Click OK

I hope that helps

let me knwo if you Need These steps for accdb.Format

beck

Anil_Babu_Samineni — Wed, 27 Jul 2016 16:35:19 GMT

John,

How do you connect direct / Thru ODBC?

beck_bakytbek — Thu, 28 Jul 2016 09:25:28 GMT

Hi John,

if you need the same way of solution for accdb.format.

Let me just know

beck