[ACCESS] DB압축

msjro.dll 참조

위치는 

C:\Program Files\Common Files\System\ado\msjro.dll

C# 버전---------------------

using JRO;

            JetEngine jet=new JetEngine();

            string current="";

            jet.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + current + ";", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=__tmp__.mdb; Jet OLEDB:Engine Type=5;");

            File.Delete(current);

            File.Copy("__tmp__", current);

-------------------------------------------------------------------------------------------------------------------

mdb 파일압축

Jett->CompactDatabase( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=org.mdb;","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=copy.mdb; Jet OLEDB:Engine Type=5;");

압축된 Org 파일을원본파일로바꿈

DeleteFile("org.mdb");

MoveFile("copy.mdb", "org.mdb");