ConnectionString for password protected Access Database

[Ansari]

Hi all,

Can anybody kindly tell me the connection string for password protected
access 2002 database.. I am using the following one but getting error

dim CN as new OLEDB.oledbConnection
cn.connectionstring = "Provider = Microsoft.JET.OLEDB.4.0; Data Source =
\\server\Costing\costing_2004_05.mdb; user id = admin; pwd= abc "
cn.open

this gives the following error
"could not find installable ISAM"

Thanks in advance

Ansari

 

[Miha Markic [MVP C#]]

Hi Ansari,

Check out
http://www.connectionstrings.com/
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDBatabase Password=MyDbPassword;"

 

[Ansari]

Hi Miha Markic

Thanks a lot.. It is working...

Ansari

Hi Ansari,

Check out
http://www.connectionstrings.com/
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDBatabase Password=MyDbPassword;"

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi all,

Can anybody kindly tell me the connection string for password protected
access 2002 database.. I am using the following one but getting error

dim CN as new OLEDB.oledbConnection
cn.connectionstring = "Provider = Microsoft.JET.OLEDB.4.0; Data Source =
\\server\Costing\costing_2004_05.mdb; user id = admin; pwd= abc "
cn.open

this gives the following error
"could not find installable ISAM"

Thanks in advance

Ansari