ODBC Connection string - Include password

[tamilarasu]

I am trying to access data from .accdb database file but the file is protected with password. I have used OLEDB connection to connect the database but the pop up window is asking to enter the password every time whenever I reload the data.

OLEDB CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\Tamilarasu.Nagaraj\Desktop\Test\PTV2.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="lptrack";Jet OLEDB:Engine Type=6;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;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False];

Can anyone explain the reason and solution please.

Thank you.

[JoaquinLazaro]

Thank you, The same to you.

Read this is you still have the password pop up ... Connect to .accdb

Maybe you need some diferent OLEDB drivers, don't forget close access db before load and tick the open shared metod in the accdb properties!!!

Joaquín

[qlikviewwizard]

Thank you TamilArasu

Nanri. Same to you.

[tamilarasu]

Yes Joaquin

I can not find the Microsoft.ACE.OLEDB.12.0 provider driver in my system. I will check and download.