connecting ms access DB 2003 WITH PASSWORD to winform app in visual studio 2008

danait25

New member
Joined
Dec 22, 2011
Messages
3
Programming Experience
1-3
Hi,
I'm using an MS Access database which has password (database password, not a workgroup or smth).
I'm using 13 characters - with no special signs- only letters.
When I try to open the DB from access it works fine, but when I try to run my Windows Form application from Visual Studio Connection String, I get a message that "Not a valid password".
In the app.config, I'm using this for connection string:
VB.NET:
<connectionstrings>
<add name="esystem.my.settings.esystemdbconnectionstring" connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\esystem.mdb;Jet OLEDB:Database Password=abcd;" providername="system.data.oledb"/>
</connectionstrings>
by the way, if I unset the password in my ACCESS DB, the connection string works perfect.
anywone have any idea what might be the problem?
Thanks.
 
G'd morning danait25,
You should check your connection, and try this:
VB.NET:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\esystem.mdb;Jet OLEDB:Database Password=abcd;
G'd luck
 
Back
Top