Clear out file based on time

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

Hi

How do you run a procedure that activates at a set time?
I want to run a procedure that moves a log file to an
archive directory at midnight (or at anytime after this
when the PC is next turned on).
Thanks for any help...
Mat
 
Mat said:
Hi

How do you run a procedure that activates at a set time?
I want to run a procedure that moves a log file to an
archive directory at midnight (or at anytime after this
when the PC is next turned on).
Thanks for any help...
Mat
Click to expand...
This newsgroup is for users of the Microsoft Access database software.
You'll probably get more help in one of the Windows newsgroups.

However, from the sound of your question, you already have the procedure
written and just neet to run it on a schedule. Try Scheduled Tasks. In
Windows 2000 you can find it under Accessories, System Tools. It may be
elsewhere in other versions.

Roxie Aho
roxiea at usinternet.com
 
Use Windows Task Scheduler (Control Panel/Scheduled Tasks on WinXP)

BTW this is a group dedicated to Microsoft Access, a database product.
 
Sorry, Perhaps I was not clear in original post.
I have an Access database that uses an external log file
to retrieve some data (eg date, email address, etc).
I want to be able to use VBA to archive the old log file
at midnight - or anytime after the next time the PC is
turned on. It will delete the original and then recreate
a new one.
I have the code to do the actual creation/deletion/move -
I am not sure about how the time part would be best
coded ?

Any ideas ...
 
Back
Top