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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tamilarasu
Champion
Champion

OLE DB Connection for Access Database

hi.gif

I am trying to connect the .accdb file using OLE DB connection string. The file is password protected and when I reload the script I am getting pop up window like below.

Capture.PNG


I have entered the password in the script. But it still asking the password and provider string. I got the below code from the below thread.


How to load MS access file in QLIKVIEW


OLEDB CONNECT32 TO

[Provider=Microsoft.Jet.OLEDB.4.0;

User ID=Admin;Data Source=C:\Users\Tamilarasu.Nagaraj\Desktop\PTrack.accdb;

Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";

Jet OLEDB:Database Password="ltrack";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";

Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;

Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

Can anyone correct the code?. sad-eyes-smiley-emoticon.gif

0 Replies