In my VB.Net project when I access an Access database without setting any
password, everything works fine. However, when I set the password and use
this connectionstring

"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\myproject\mydatabase.mdb;Jet OLEDB:Database Password=test;"

I get message, "invalid password".

My password is "test". When I open Microsoft Access I have to enter this
password "test" then only I can see my database. However, when I try to
access thru code it says "invalid password".  However if remove the password
and change the connectionstring to as follows everything works fine.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myproject\mydatabase.mdb;"

What's the problem ?

Thanks in advance.

Patang,

Did you tried it with adding a user id.

";User Id=admin;Password=Test;"

I hope this helps,

Cor

http://www.connectionstrings.com

Crouchie1998
BA (HONS) MCP MCSE

Crouchie1998,

Mhm... the connection string there looks very similar to the OP's connection
string.

cint and int32.parse
Hide unwanted properties.
Connection pool problems
My application exits after handling an ApplicationException
Error after removing row and then adding new row to datatable
Lines and Boxes in VB.Net
Public Variables in Module1
How to copy files from desktop to web server
Bound combo box problem
Deserialization version mismatch