Backing up a Microsoft Access database

• This is applicable to Microsoft Access databases ONLY. To backup an SQL database, please contact your SQL Database Administrator.

Basically, the backup utility simply makes a COPY of your database and stores it in your Backups folder.

To set your database to automatically backup at regular intervals

1. Click File and then Open

2. The Open Databases dialog box is shown

   

    

3. Select the database you want to adjust and click Properties

4. The Database Properties dialog box opens:

   

    

5. In the Auto Backup field, select the frequency of your backups (default is once a week) and the number of backup copies to keep (default is 2).

   • The default settings will create 2 backups of your database named <database>1.mdb and <database>2.mdb.

6. These backups will be stored in your Backup folder.

7. The backups are overwritten in order (for example, if you make 2 backups, the 3rd time the routine runs, the first backup copy will be overwritten).

To manually backup your database

1. Click File and then Open

2. The Open Database dialog box is shown

   

    

3. Highlight the database you would like to backup and click the Backup button

4. You will receive confirmation that the backup is complete:

   

Safeguarding your backups

• On Center recommends that you store your backups on a drive OTHER than your local hard drive.

You can change the folder to which backups are made by selecting , Options, and then Folders:

Click the lookup button (magnifying glass) to browse to an alternate location where you want to store your backups. On Center Software recommends a network location if possible.

7.00 Setting Database Preferences