C# compact and repair access database

Question

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

Karenjit Kaur · Answer

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 Smith · Answer

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;