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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you disable Compact on Close in code? 2
Access 2007: Escape Out of Compacting Corrupts Database - Database1.zip (0/1) 17
Compact on close 3
Compacting 1
compact database from command prompt 1
Error 7846 Can't compact and repair current database 2
Compact problem 5
Compact and Repair Using Scheduled Tasks 2

Back
Top