ConnectionString for password protected Access Database

  • Thread starter Thread starter Ansari
  • Start date Start date
A

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
 
Hi Miha Markic

Thanks a lot.. :) It is working...

Ansari

Miha Markic said:
Hi Ansari,

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

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

Ansari said:
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
Click to expand...
Click to expand...
 
Back
Top