c# - 如何使用 C# 压缩 Msaccess 数据库

Question

是否可以使用 c# 压缩 Msaccess 数据库，如果可以，请告诉我方法？

Answer 1

你可以试试这样的东西

public static void CompactAndRepair(string accessFile, Microsoft.Office.Interop.Access.Application app)
        {
            string tempFile = Path.Combine(Path.GetDirectoryName(accessFile),
                              Path.GetRandomFileName() + Path.GetExtension(accessFile));

            app.CompactRepair(accessFile, tempFile, false);
            app.Visible = false;

            FileInfo temp = new FileInfo(tempFile);
            temp.CopyTo(accessFile, true);
            temp.Delete();
        }

另见 Use the CompactRepair method of the Application object to compact and repair the database