Using UDL file for Connecting Access Database

Hi
I am using a UDL file to connect to MS Access database. Currently my database is not password protected. I need to know how can access password protected MDB and access the same using UDL. Please note that I do not want to specify the Password in UDL file, I want to hardcode the same within the application in Connection String.

Currently my string looks like

constr = "File Name = " & UdlFileName

I do not want to specify password in UDL as one can see that if they opened that in Notepad.

Please help as soon as possible.

Regds
Ashish P
ashishpayasiAsked:
Who is Participating?
 
AerosSagaConnect With a Mentor Commented:
the connection string should be constructed like so:

#   Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"


#  Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;"


#  With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

Regards,

Aeros
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.