Automatic Backup for Access Files
Do you have Access databases open throughout the workday, with people entering and editing data? In Access, data is saved automatically as you work, but it’s a good precaution to have a backup of the entire file, so you can recover if something goes wrong.
To make backups easy to manage, Jan Karel Pieterse has created the Access Backup Tool, available as a free download on his web site. I tested it in Access 2007 and Access 2003, and it worked well in both version.
Open the Access Backup Tool and the Menu form will appear automatically.
Click the Settings button, to open the Settings form where you can enter the information about your databases.
In the Settings form, enter the file path to each database, and the location where you want the backup stored.
Timed or Manual Backups
At the top of the Settings form, you can enter the backup settings.
- For automatic backups, add a check mark to Timed Backup, and set the time interval for the backups. Then the backup process will run automatically, at the specified interval.
- For manual backups, remove the check mark for Timed Backups.
Suspend Backups Overnight
If backups aren’t required overnight, you can suspend them during specified hours.
- To stop backups overnight, add a check mark to Suspend backup. Enter the stop and start times for the backups.
- To run the backups around the clock, remove the check mark from Suspend backup
Start the Backups
After you’ve entered all the settings, close the Settings form and return to the Menu.
On the Menu form, if you opted for Timed Backup, you’ll see the countdown to the next backup. At the specified interval, the backup will run, and you’ll see a notice on the menu.
Leave the Access Backup Tool running all day, and it will take care of the backups for you automatically.
If you’d prefer to run the backups manually, click the Backup Databases button, and all the selected databases will be backed up.