Access a MS Access DB that have a password
Posted on 2006-07-12
I want to access a database that have a password and the code give me an exception : the file is already open by another user or it's open exclusively. The problem is that the file is not in exclusive mode or open by another user. If I remove the password and set the opening mode to normal, i've got no errors, but if i leave the password, i got the error. Even if I open it witn normal mode.
String accessConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;
OleDbConnection myConnection = new OleDbConnection(accessConnStr );
myConnection.open(); // the exception appears when it attempt to connect.
Can someone help me plz???