schedule compact mdb

[-EvaMendes]

How can I run a compact and repair mdb daily at certain time? Thanks.

 

[Arvin Meyer [MVP]]

How can I run a compact and repair mdb daily at certain time? Thanks.

You can build an application in Access or VB which will do the compaction,
and run it using the Windows Scheduler, or any other program which allows
scheduling. You can also use FMS's Agent:

http://www.fmsinc.com/Products/Agent/index.html

 

[-EvaMendes]

HI,

If I am using access 97, how can I do it exactly? Can you please
give me some guideline or example? Thanks.

 

[Arvin Meyer [MVP]]

Try this line of code:

DBEngine.CompactDatabase "c:\yourdir\oldname.mdb", "c:\yourdir\oldname.mdb"

You'll need to do it from another database which is open.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com