public bool LoadAccess(string sPath, string sDBPass, string sUser, string sUserPass) //,out string errStr)
{
try
{
sOriginalPath = sPath;
this.Text = this.Text + " - " + System.IO.Path.GetFileName(sPath);
sBackupPath = sPath + ".BACKUP";
System.IO.File.Copy(sOriginalPath, sBackupPath, true);
sConnectionString = ConnectionStringSelector.MakeAccessConnectionString(sOriginalPath, false, true, sDBPass, sUser, sUserPass);
ConnectionStringSelector.InsertValue(ref sConnectionString, "Password", sUserPass);
ConnectionStringSelector.InsertValue(ref sConnectionString, "Jet OLEDB:Database Password", sDBPass);
qry = new EasyQuery();
Connection objCn = new Connection();
objCn.DatabaseType = typeof(OleDbConnection);
objCn.ConnectionString = sConnectionString;
qry.DatabaseConnection = new ConnectionItem(objCn);
qry.Description = "Table editor";
//
objCn.SetCredential(sUser, sUserPass, sDBPass);
schema.dbCon = objCn;
schema.LoadSchema();
loadTables();
return(true);
}
catch (Exception er)
{
FormLog.NotifyException(true, er);
}
finally
{
}
return(false);
}
