I am writing a very challenging db for backups. The use can select the day and time for the backup.
Here is my question: What would be the best approach to make sure that the backup actually backed up on time or not?
I can of course check and if it was missed, notify the user and they can choose backup now or cancel.
The backup timer ONLY works when the db is open. NOT going to get into writing a script or batch file to deal with that.
Since frmBackup is used to set the day and time for the backup, it has the textbox for the time on it.
If that form is not open of course the backup wont run. I can make it hidden when the db opens would be one way.
Am I not seeing the forest because of the trees?
TimerEvent Question
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: TimerEvent Question
If you want the backup code to run, the PC must be on, the database must be open, and the form with the On Timer event must be loaded (visibly or hidden, that doesn't matter).
You could create a scheduled task to open the database...
You could create a scheduled task to open the database...
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: TimerEvent Question
Thanks, it is as expected, not perfect but better than nothing.
Merry Christmas Hans, Wish you and the family the best, Happy Holidays.
Merry Christmas Hans, Wish you and the family the best, Happy Holidays.
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands