public msAccProcs(String fileaName)
{
try
{
Char quote = Convert.ToChar(34);
String Conn1 = "Data Source=" + quote;
String Conn2 = fileaName;
String Conn3 = quote + ";Provider=" + quote + "Microsoft.Jet.OLEDB.4.0" + quote + ";";
//Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
theConnString = Conn1 + Conn2 + Conn3;
OleDbConnection EmptyDBConn = new OleDbConnection(theConnString);
EmptyDBConn.Open();
if (EmptyDBConn.State == System.Data.ConnectionState.Open)
{
EmptyDBConn.Close();
theConn = EmptyDBConn;
isGood = true;
}
else theConnString = "";
}
catch
{
theConnString = "";
}
}