OLE DB Connection for Access Database

tamilarasu — Tue, 07 Apr 2015 02:35:56 GMT

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.

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?.

topic OLE DB Connection for Access Database in QlikView

OLE DB Connection for Access Database