chrisgreen
Programmer
I want to run a procedure once a day automatically. Is this possible. If so how?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running procedures once a day (on a timer)
- Thread starter chrisgreen
- Start date
- Status
Yes, it is possible. There are a number of approaches. When do you want to run it? Can your Access Db be left open during the time you want to run it?
If you can leave the Db open, then you can design a form and set the Timer event to run your code. Check out Timer in the help files.
If you can't leave the Db open, then you need to schedule a task, which will open your Db for you. You could either design a form which runs when the Db opens and has the procedure in it's Form_Load event, or you could call your code from the AutoExec macro. There's a help topic on running events when a Db opens.
As to how the task would be scheduled, that depends on your operating system. I would ask your company's network guys about it.
Good luck.
If you can leave the Db open, then you can design a form and set the Timer event to run your code. Check out Timer in the help files.
If you can't leave the Db open, then you need to schedule a task, which will open your Db for you. You could either design a form which runs when the Db opens and has the procedure in it's Form_Load event, or you could call your code from the AutoExec macro. There's a help topic on running events when a Db opens.
As to how the task would be scheduled, that depends on your operating system. I would ask your company's network guys about it.
Good luck.
Chrisgreen,
You may be interested in this. Its shareware that you can download. I haven done much other than try it out, but it seems its pretty simple and seems to work. If you download and install the program, the help files give examples of how to use it to open an MDB and execute procedures. You can set it up to execute daily, weekly, specific times, and certain days of the week. It will also do timed MDB backups and compacts. It generates log files and error files.
Dave
You may be interested in this. Its shareware that you can download. I haven done much other than try it out, but it seems its pretty simple and seems to work. If you download and install the program, the help files give examples of how to use it to open an MDB and execute procedures. You can set it up to execute daily, weekly, specific times, and certain days of the week. It will also do timed MDB backups and compacts. It generates log files and error files.
Dave
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question