[AccessD] Automatic backup

[John R Bartow]

I want to add a backup routine that runs when anyone closes the database.
There aren't any action queries or anything like that at this point and
although it will be on a server, I can't imagine a time when more than one
person will be updating records - we're going to have an employee (not me)
dedicated to that.

>>> Count on more than one person using it just because you're not counting
on it.

Currently, there's no reason to split it, so I'm not going to. So, a backup
routine should be fairly simple. I can train the other employee to do it
manually and she will - she's competent and even if she forgot occasionally,
updates are very limited. Most of the info is in there and they want reports
- updates are ... there are updates, just not daily and not a lot.

>>>There is also no reason not to split it. Favor always goes to splitting
it. While she may be competent, you have no idea how long she may be there.
Her replacement may be incompetent. You also have no idea how long you will
be there. 

I'm thinking... train her not worry about it. We have electronic and paper
files of all the updates and reentering would take... at the very worst a
few hours if the worst happened.

>>>Reentry is not a good backup plan. Although it is a good reason not to
have to have it backed up immediately. So, use a simple windows command line
batch file to make backups every night. Schedule it in the Windows
Scheduler. Or use DropBox and schedule it to back up to the cloud once a day
when the office is closed.

Recommendations? Thoughts?

>>>Count on at least 2 concurrent users. Split it. Don't over complicate
backing it up.