public static void CompactAccessDB(string strMdbName)
{
   string TempMdbName = Application.StartupPath + @"\Temp.mdb";
 
   //創(chuàng)建 Jet 引擎對(duì)象
   object objJetEngine = Activator.CreateInstance(Type.GetTypeFromProgID("JRO.JetEngine"));
 
   //設(shè)置參數(shù)數(shù)組
   //根據(jù)你所使用的Access版本修改 "Jet OLEDB:Engine Type=5" 中的數(shù)字.
   //5 對(duì)應(yīng) JET4X 格式 (access 2000,2002)
 
   object[] objParams = new object[] {
     String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}",strMdbName), //輸入連接字符串
     String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Engine Type=5",TempMdbName) //輸出連接字符串
     };
 
   //通過(guò)反射調(diào)用 CompactDatabase 方法
   objJetEngine.GetType().InvokeMember("CompactDatabase",
       System.Reflection.BindingFlags.InvokeMethod,
       null,
       objJetEngine,
       objParams);
 
   //刪除原數(shù)據(jù)庫(kù)文件
   System.IO.File.Delete(strMdbName);
   //重命名壓縮后的數(shù)據(jù)庫(kù)文件
   System.IO.File.Move(TempMdbName, strMdbName);
   //釋放Com組件
   System.Runtime.InteropServices.Marshal.ReleaseComObject(objJetEngine);
   objJetEngine = null;
}