The
Connection String for
MS Access can be set as ;
private constr =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
Jet OLEDB:Database Password=yourpassword;";
And the
C# code to connect to
MS Access database ;
public bool OpenConnection()
{
OleDbConnection con; con = new OleDbConnection(constr);
if (con.State != ConnectionState.Open)
{
try
{
con.Open(); return true;
}
catch (Exception) { return false; }
}
else return false;
}
C# Access Connection String OLE DB OleDbConnection password field is the password you set up in access database.