opening a password protected database 1

[ajbFL05]

I have created a database in access 97 and would like to make it password protected. I am calling this from a VB .net program and am unable to access the database. I am setting the password in access under tools -> security -> set database password. Am I setting the wrong password?

Here is what the code looks like

Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\mydb.mdb;Jet OLEDBatabase Password=one;"

Dim myDataAdapter As New OleDbDataAdapter(commandString, connectionString)

Dim myDataSet As New DataSet
myDataAdapter.Fill(myDataSet, "mydb")


this is the error I get

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

any help with this would be great

thanks

 

[153]

There is no problem with the password.
Just where is the connection.You only set the connection string, but not the connection.
You must declare the connection first, it's like:
"Dim Conn As New OleDbConnection(your_connection)"

Hope this can help you.