Hi Dave,
I run lots of 'auto tasks' on my company access databases and have always found the easiest way is to create either a macro or a module(called from a macro) which does the work and then on the server/pc thats never turned off set a scheduled task,
ie:
C:\PROGRA~1\MICROS~3\Office\MSACCESS.EXE i:\choice\contracts.mdb /x reminder
the macro : reminder
in the database : contracts.mdb
is scheduled to run on the 1st of every month.
This is a great way to set it and forget it,
I have built into the macro error handling as well so that should the macro/module fail -I get an email telling me the database name, macro name and the error, so I can sort out the problem.
Also, I would advise to start with have the macro/module send you an email to let you know it worked!
hope this helps.
|