automatically repair and compact database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several multiuser database that I would like to repair and compact a
few times a week, without user interaction. Right now I have a macro that
does the repair and compact. The problem is it prompts for Yes or no to
replace the database (this should always be yes). I have not found a way to
automatically say yes to the prompt. Is there a way to use code to repair
and compact the databases with out user interaction?

Thanks
 
Make a scheduled task that runs automatically and points to the database, but
with the /compact command-line switch. That is,
C:\YourPathHere\YourProgram.mdb /compact. This will compact and repair
automatically on opening.
 
Back
Top