Show All

Back up and restore an Access database (MDB)

Back up an Access database

1. Save and close all objects in the database.
2. On the File menu, click Back Up Database.
3. In the Save Backup As dialog box, specify the name and location of the backup copy.

   Caution  If you are using user-level security, you should also create a backup of the workgroup information file. If this file is lost or damaged, you won't be able to start Microsoft Access until you restore or rebuild it.

Restore an Access database from a backup copy

• Depending on what method was used originally to produce the backup copy, use My Computer, the Windows 2000 or later Backup and Recovery Tools, or other backup software to copy the backup Access database to your database folder.

  Caution  If the existing Access database in the database folder and the backup copy have the same name, restoring the backup copy may replace the existing file. If you want to save the existing file, rename it before you copy the backup database.

Note  You can back up individual database objects by creating a blank database and then importing the objects you want from the original database.