OLE DB Connection for Access Database

tamilarasu — Tue, 07 Apr 2015 02:57:26 GMT

I am trying to connect a .accdb file by using OLEDB connection string. When I reload the the data, I got below prompt window to enter password and provider string. I have already entered the password in the connection string, but not sure where I am wrong.

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];

I got the above code from the below link.

How to load MS access file in QLIKVIEW

in advance.

Re: OLE DB Connection for Access Database

Gysbert_Wassenaar — Tue, 07 Apr 2015 10:36:04 GMT

Wrong driver. You don't need the jet4 driver, but the Microsoft.ACE.OLEDB.12.0 provider. See this discussion: Re: Load .mdb without Access installed?

Re: OLE DB Connection for Access Database

buzzy996 — Tue, 07 Apr 2015 10:41:28 GMT

if u like to use ODBC, u can also simply create connection string and fetch the data from source MS access db,drivers are installed for this by default.

topic Re: OLE DB Connection for Access Database in QlikView

OLE DB Connection for Access Database

Re: OLE DB Connection for Access Database

Re: OLE DB Connection for Access Database