大的方面使用odbc, OLEDB;LINQ to access等等都行
例子: http://altafhussainbd.wordpress.com/2010/08/05/working-with-ms-office-access-database-mdb-and-c/
http://stackoverflow.com/questions/295772/query-microsoft-access-mdb-database-using-linq-and-c
using System.Data;
using System.Data.Oledb;
......
string strSQL="SELECT * FROM TableABC";
OledbConnection conn=new OledbConnection();
conn.ConnectionString="Provider=Microsoft.Jet.Oledb.4.0;Data Source=D:\data.mdb";
OledbDataAdapter adp=new OledbDataAdapter(strSQL,conn);
DataTable dt=new DataTable();
adp.Fill(dt);
for(int i=0;i<dt.Rows.Count;i++)
{
doing sth...;
}
找MSDN吧。
跟连Sql server一样,只不过把Sql ***** 改成Oledb ********.