Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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
MVP
MVP

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