Log In

Interactive Tutorial

Back Up and Restore a Database

How to Back Up and Restore a Database in Access

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this course with a Free Trial

Interactive Tutorial

Practice live in your browser. No software required.

Try It Now

Access 2021 Basic Course

5 Hour Course Certificate

View Course

Access 2021 Basic Cheat Sheet

Free quick tips and shortcuts to use and share.

Download Cheat Sheet

Reference Guide

Step-by-step instructions with screenshots.

Reference Guide
Back Up and Restore a Database

You can create a backup copy of your database in case of a system failure or if the Undo command isn't enough to fix a mistake.

Back Up a Database

It's important to back up your database on a regular basis, as without one you can't restore corrupted or missing objects.

  1. Open the database you want to back up and click the File tab.
    Back Up a Database
  2. Select Save As.
  3. Select Back Up Database.
  4. Click Save As.
    Back Up a Database

    The Save As dialog box appears. Here you can specify where you want to save the backup.

  5. In the Save As dialog box, specify a location and name for the backup.
  6. Click Save.
    Back Up a Database

Access creates a backup copy of the database.

Restore a Database

When you restore a whole database, you replace a database file that is damaged, has data problems, or is missing completely with a backup copy of the database.

  1. Open File Explorer and navigate to the location of the last known backup of the database.
  2. Copy the backup of the database.
    Restore a Database
  3. Navigate to the location of the damaged or missing database and paste the backup database.

The backup of the database appears.