用Delphi压缩Access数据库

procedure CompactMdbDatabase(srcDbname,dstDbname,oldpwd,newpwd:string;bAccess97:boolean=true);

var idbEngine:_dbEngine;

begin

if oldpwd <>'' then oldpwd := ';pwd='+oldpwd;

if newpwd <>'' then newpwd := ';pwd='+newpwd;



if bAccess97 then

begin

idbengine := CreateComObject(dao97.CLASS_DBEngine) as _DBEngine;

idbEngine.CompactDatabase(srcDbname,dstDbname,newpwd,dbVersion30,oldpwd);

end else

begin

idbengine := CreateComObject(dao2000.CLASS_DBEngine) as _DBEngine;

idbEngine.CompactDatabase(srcDbname,dstDbname,newpwd,dbVersion40,oldpwd);

end;

end;