automatically repair and compact database

[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

 

[Guest]

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.