Using a database password

[Z_799]

Jim,

You're connection string syntax is slightly wrong. Try
the following:

Dim strConnection As String
= "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\temp\db1.mdb;

Jet OLEDB:Database Password=one;

"

Thomas

-----Original Message-----
I have a .NET 2003 WinForm application that pulls data
from an Access database.

If I set the database password to 'one', and run the
following code I get an error message that reads 'Could
not find installable ISAM.'

Dim strConnection As String
= "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\temp\db1.mdb; PWD=one;"
Dim cnn As New OleDbConnection(strConnection)
Try
cnn.Open()
Catch exp As Exception
Console.WriteLine(exp.Message)
End Try

When I remove the password from the database and modify
the connection string, the app works fine.

What do I need to do in order to use a password on an
Access database?

Thanks.
.