Board index » delphi » Compact MS Access Database

Compact MS Access Database

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

 

Re:Compact MS Access Database


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

No

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

Re:Compact MS Access Database


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

Quote
>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

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

Re:Compact MS Access Database


I think the message wanted something OTHER  than OLE.

Woody

Other Threads