How can I schedule a report to run say every Monday morning without manual
intervention?
One way to do so is to create a Macro (one of the few times I use macros
actually!) named RunReport which does two things: runs the report, and closes
Access.
Then use Windows Scheduler to open Access using a command switch to run the
macro: The command line should be something like
"C:\Program Files\yadayada\msaccess.exe" "K:\path\yourdb.mdb" /x RunReport
John W. Vinson [MVP]