如果用DAO的话只能压缩没密码的数据库。不知道有谁知道如何做.以下是抄来的东东,不知道是从哪来的,不好意思。function CompressAccessDB(DBName:string):Boolean; var JetEngine:OleVariant; tmpName:string; begin Result := False; if not FileExists(DBName) then Exit; tmpName:= '_cd1010.mdb'; try JetEngine := CreateOleObject('JRO.JetEngine'); except Exit; end; try JetEngine.CompactDatabase('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + DBName,'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + tmpName); except Exit; end; if DeleteFile(PChar(DBName)) then if RenameFile(tmpName,DBName) then Result := True; end;
http://www.kingron.myetang.com/
var
JetEngine:OleVariant;
tmpName:string;
begin
Result := False;
if not FileExists(DBName) then Exit;
tmpName:= '_cd1010.mdb';
try
JetEngine := CreateOleObject('JRO.JetEngine');
except
Exit;
end;
try
JetEngine.CompactDatabase('Provider=Microsoft.Jet.OLEDB.4.0;Data Source='
+ DBName,'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + tmpName);
except
Exit;
end;
if DeleteFile(PChar(DBName)) then
if RenameFile(tmpName,DBName) then
Result := True;
end;