SQL - Connect to pwd protected database

[dwlerwill]

I need to connect to a database on access but it is password protected. I can not seem to get the code right to send the password with the connection string

I have

db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=S:\RESPONSE\Horizon\Data Store\Horizon_Tables.mde; pwd=HeLlO"

But it comes back with the error

Couldn't find installable ISAM. Can someone help with this.


David Lerwill
"If at first you don't succeed go to the pub"

 

[johnwm]

My usual method for dealing with an error message that I don't understand is to stick it into Google search engine. In this case you get quite a number of MSDN references, listing several alternatives, depending on your circumstances.

You can start from here:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q155666

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[peresr]

Why aren't you using:

connectionname.ConnectionString = "Provider=SQLOLEDB;Data Source=slh_helpdesk;User ID=sa;Password=sa;Initial Catalog=databasename"

connection.Open

I'm not sure if this would work in your version on Vb, but it works great for me in VB6.