C# compact and repair access database

David Smith

16y8.4k.NET

Do some one know how to compact and compare access database through code, i know how to do it outside of code, I want to automate the compact and compare option through code after i import data or delete data in the database

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karenjit Kaur8y ago
I would recommend a 3rd-party access recovery tool to repair corrupt access database file. It gives you smart and reliable solution. With this tool, you can get corrupt ACCDB and MDB database files back to a new one. You can just download this tool at http://www.softmagnat.com/access-database-repair.html
David Smith16y ago
      object[] oParams;

      object objJRO =
        Activator.CreateInstance(Type.GetTypeFromProgID("JRO.JetEngine"));

      oParams = new object[] {
        Properties.Settings.Default.ConnectionString,
        "Provider=Microsoft.Jet.OLEDB.4.0;Data" +
        " Source=C:\\ElauDatabase.mdb;Jet OLEDB:Engine Type=5"};



      objJRO.GetType().InvokeMember("CompactDatabase",                             ////////// I get a error right here at this line, Exception has been thrown by the target of an invocation.
          System.Reflection.BindingFlags.InvokeMethod,
          null,
          objJRO,
          oParams);

      System.IO.File.Delete(Properties.Settings.Default.ConnectionString);
      System.IO.File.Move("C:\\Database.mdb", Properties.Settings.Default.ConnectionString);

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