how to Compact database Programmatically

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Greeting,
I have an Access 2000 application, I plan to compact my
database automatically at a schedule time. I created an
form with OnTimer event, when system time match the
schedule time it will compact the databse. But
the "DBEngine.CompactDatabase(sourceConnection,
DestConnection)" command can't compact the same databsae.
It will compact and copied to a new name. But I want to
have the same name? Is there a way to work around?
Thanks.
 
Yes. On my website (see sig below) called "CompactDatabase" which
illustrates how.
 
Back
Top