How to Back up a Microsoft Access Database

Mike Chapple

You store critical data in Access databases every day. Have you ever stopped to consider whether you're taking appropriate actions to protect your database in the event of a hardware failure, disaster, or other data loss?

Microsoft Access provides built-in functionality to help you back up your databases and protect your organization. You can store the backup file anywhere, be it on an online storage account or just a flash drive or external hard drive.

Make an Access Database Backup

These steps are relevant to MS Access 2007 and newer, but make sure to follow the instructions that pertain to your version of Access, be it 2010, 2013, or 2016. See how to back up a 2013 Access database if you need help there.

Start by opening the database you want to have a backup for, and then follow these steps:

MS Access 2016 or 2013

  1. Go into the File menu.
  2. Choose Save As and then click Back Up Database from the "Save Database As" section.
  3. Click the Save As button.
  4. Choose a name and pick where to save the backup file, and then click Save.

MS Access 2010

  1. Click on the File menu option.
  2. Choose Save & Publish.
  3. Under "Advanced," select Back Up Database.
  4. Name the file something memorable, place it somewhere easy to access, and then choose Save to make the backup.

MS Access 2007

  1. Click the Microsoft Office button.
  2. Choose Manage from the menu.
  3. Select Back Up Database under the "Manage this database" area.
  1. Microsoft Access will ask you where to save the file. Choose an appropriate location and name and then click Save to make the backup.

Tips:

  • After backing up the Access database, open the backup file in MS Access to verify that it completed successfully.
  • For optimal protection, store a copy of your database backups in an offsite location on a periodic basis. If it's a personal database that rarely changes, you might want to put a CD copy in a safe deposit box quarterly. Critical business databases might be backed up to magnetic tape on a daily (or more frequent) basis.
  • Make database backups part of your regular safe computing routine.
  • You may wish to optionally encrypt your database backups if your database contains sensitive information. This is a great idea if you plan to store it remotely.

Format
mla apa chicago
Your Citation
Chapple, Mike. "How to Back up a Microsoft Access Database." ThoughtCo, Aug. 2, 2017, thoughtco.com/back-up-a-microsoft-access-database-1019936. Chapple, Mike. (2017, August 2). How to Back up a Microsoft Access Database. Retrieved from https://www.thoughtco.com/back-up-a-microsoft-access-database-1019936 Chapple, Mike. "How to Back up a Microsoft Access Database." ThoughtCo. https://www.thoughtco.com/back-up-a-microsoft-access-database-1019936 (accessed January 22, 2018).