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