y ni asi...

string cnStr;

string fichero = "..\\..\\bd1.mdb ";

int resultado;

cnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fichero;

SqlConnection testConnection = new SqlConnection(cnStr);

SqlCommand testCommand = testConnection.CreateCommand();

testCommand.CommandText = "select count(*) from mayoristas";

testConnection.Open();

resultado = (int)testCommand.ExecuteScalar();

testConnection.Close();