Connectionstring

[Guest]

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 OLEDBatabase 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.

 

[Cor Ligthert]

Patang,

Did you tried it with adding a user id.

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

I hope this helps,

Cor

 

[Crouchie1998]

http://www.connectionstrings.com

Crouchie1998
BA (HONS) MCP MCSE

 

[Herfried K. Wagner [MVP]]

Crouchie1998,

http://www.connectionstrings.com

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