Connectio to a password protected Access database 1

[diarratech]

The Server Explorer in Visual Basic.Net does let me connect to a password protected Access database using Jet 4.0 OLE DB provider. I have a connection test failure. It works fine without any password.
The same problem occurs using a connection string in code!!
What seems to be the problem?
Thank you for your help

 

[PankajBanga]

specify the password in the connection string

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/myDB.mdb;Jet OLEDBatabase Password=" + password

 

[diarratech]

Thank you very much! The connection string works great now! But I don't know why it was not working with the Server Explorer