Code to Automate Archiving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Allen,
Thank you very much for your help. One last question. Can this be done
using Access 97?
 
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?
 
Back
Top