public static string BuildAccessConnectionString(string databaseFile)
{
string dbLower = databaseFile.ToLower();
if (dbLower.Contains(".mdb"))
return BuildAccessConnectionString(AccessOleDbProvider2000, databaseFile);
else if (dbLower.Contains(".accdb"))
return BuildAccessConnectionString(AccessOleDbProvider2007, databaseFile);
else
throw new InvalidOperationException(string.Format("Unrecognized file extension on database file '{0}'", databaseFile));
}