تابعی برای تعمیر و فشرده سازی پایگاه داده Access

[Ghoghnus]

کد:

public static void CompactAccessDB(string connectionString, string mdbfilename)

{

object[] oParams;

object objJRO =

Activator.CreateInstance(Type.GetTypeFromProgID("JRO.JetEngine"));

oParams = new object[] {

connectionString,

"Provider=Microsoft.Jet.OLEDB.4.0;Data" +

" Source=C:\\tempdb.mdb;Jet OLEDB:Engine Type=5"};

objJRO.GetType().InvokeMember("CompactDatabase",

System.Reflection.BindingFlags.InvokeMethod,

null,

objJRO,

oParams);

System.IO.File.Delete(mdbfilename);

System.IO.File.Move("C:\\tempdb.mdb", mdbfilename);

System.Runtime.InteropServices.Marshal.ReleaseComObject(objJRO);

objJRO = null;

}