Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview

Hi all,

Requesting your suggestion on the following error:


please suggest me

1 Solution

Accepted Solutions
beck_bakytbek
Master
Master

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

View solution in original post

4 Replies
Anonymous
Not applicable
Author

any suggestion please

beck_bakytbek
Master
Master

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

John,

How do you connect direct / Thru ODBC?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
beck_bakytbek
Master
Master

Hi John,

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

Let me just know

beck