کد زیر رو امتحان کن.....
var
despath : string
ole : oleVariant;
connection.Close;
ole := CreateOleObject('DAO.DBEngine.36');
ole.CompactDataBase(ExtractFilePath(ParamStr(0))
+ 'c:\DB.mdb' , ExtractFilePath(paramStr(0)) + 'c:\DB1.mdb');
DeleteFile(ExtractFilePath(paramStr(0)) + 'c:\DB.mdb');
RenameFile(ExtractFilePath(ParamStr(0))
+ 'c:\DB1.mdb' , ExtractFilePath(ParamStr(0)) + 'c:\DB.mdb');
despath := ExtractFilePath(Application.ExeName);
despath := despath + 'c:\DB.mdb';
connection.ConnectionString := despath
connection.open;