How to Compact Access 2007 Database Programmatically

Add a reference to “Microsoft Office 12.0 Access Database Engine Object Library”.



And write a following code to compact the Access 2007 Database:-

// Create a new object of DBEngine

Microsoft.Office.Interop.Access.Dao.DBEngine objDbEngine = new Microsoft.Office.Interop.Access.Dao.DBEngine();

// Call the CompactDatabase method on object of DBEngine

objDbEngine.CompactDatabase(“C:\SourceDB.accdb”, “C:\TargetDB.accdb”, null, null, ";pwd=passwordOfDatabaseIfAnyElseNULL");

For more information about the function parameters refer to the following link:-

http://msdn.microsoft.com/en-us/library/bb220986.aspx