打印本文 打印本文 关闭窗口 关闭窗口
用Delphi 压缩Access数据库
作者:武汉SEO闵涛  文章来源:敏韬网  点击数1088  更新时间:2009/4/23 18:31:08  文章录入:mintao  责任编辑:mintao

uses dao97,dao2000;


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;

打印本文 打印本文 关闭窗口 关闭窗口