Backing up an Access 2013 database preserves the integrity and availability of your important data. This step-by-step article describes how to back up an Access 2013 database.
Microsoft Access includes a robust backup and restore feature that makes creating and maintaining a backup as simple as point and click. This tutorial uses built-in functions to create a database backup.
- Ready to back up
- Open the database
- Close all database objects
- Select the option Save as
- Choose a backup file name
Ready to back up
Microsoft Access is backed up on a database basis. You must repeat these steps for each database you use. Backing up one database will not back up any other databases that you may have stored on the same system. Also, database backup does not save any other data stored on your system. After you are done setting up database backups, you should also make full backups of your computer.
If you have multiple users in your database, all users should close their database before backing up to save any data changes.
Open the database
Start Microsoft Access 2013 and open the database. Backups are database specific and you must repeat this process for each database you want to protect.
Close all database objects
Close all open database objects such as tables and reports. When you complete this operation, your access panel should look like the one shown here. The only element you should see is the object browser.
Select the option Save as
On the menu File Select option Save as and then the parameter Save database as † In the “Advanced” section of this window, select “ Create a database backup and press the button Save how †
Choose a backup file name
Give your backup file a name and location. Use the file browser window to open any location on your computer. The default file name appends the current date to the database name. Click Save †