Is there an easier way to compact an MS Access database using the BDE rather
than resorting to using OLE Automation?

Paul Bartlett
pa...@drs.co.uk

No

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

On Fri, 11 Sep 1998 23:46:52 +0100, "Paul Bartlett" <pa...@drs.co.uk>
wrote:

i found the follow in germany:

delphi usergroup mnchen / Tips & Tricks
http://ourworld.compuserve.com/homepages/reiter_software/delphi/index...

Access DB komprimieren

  vor kurzem habe ich einen Weg gesucht, Access Datenbanken von Delphi
aus zu komprimieren. Hier  eine L?sung:

  uses
    ComObj;

  ...
  daoEngine := CreateOleObject( 'DAO.DBEngine' );
  // ich denke die datenbank muss exclusive ge?ffnet werden
  daoEngine.CompactDatabase( dbName, 'tmp.$$$' );
  daoEngine := unassigned;
  RenameFile( dbName, ChangeFileExt( dbName, '.BAK') );
  RenameFile( 'tmp.$$$', dbName );
  ...

  Have fun,

Gerhard ?ttl
gerhard.oe...@wvnet.at

I think the message wanted something OTHER  than OLE.

Woody