Code to Automate Archiving

N

nmarano

We have several apps that were written in Access and every two weeks, we have
to archive our databases based on certain dates. I was wondering if anyone
was aware of a way to automate this process? If so your help would be
greatly appreciated.
Thanks
Nick
 
A

Allen Browne

If the computer is on, and the database is open, you could leave a (hidden)
form open, and use its Timer event to periodically check the value of Now()
and run the routines on cue.
 
N

nmarano

Allen,
Thank you very much for your help. One last question. Can this be done
using Access 97?
 
N

nmarano

Allen,

Would I be better off setting up a Macro and then using a Windows Scheduler
to call the Macro which would run the module set up to archive?
 
Top