Skip to main content
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