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:
<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?