Scheduled run of Compact-Repair off hours

[techexpressinc]

There should be a way to run an "auto-marco" as in Excel that does the Compact and Repair that can be put on an XP-Scheduler to run nightly.

If anyone has this process working let me know.



Thx

Russ

Russell.Neuman @ LFG.com

I will post one if I figure it out.

[ajetrumpet]

Russ,

you can open a specific application (access file) with the task scheduler. so that means you can do that, and on load of the file use an AUTO EXEC macro to do what you need it to do.

you can even leave that macro in there permanently and simply do an IF check at the start of a procedure to see if the clock's time requires the compact and repair. for instance, if it's day time, exit the procedure.