Ways To Backup And Restore Access Database

If you are looking to protect your Access data, then only encrypting the database is not enough. Besides that maintaining the proper backup of Access database is also equally important for MS Access users. So, that when MS Access database get lost, corrupt, missing or if database design is changed, even then also you can easily restore them completely.

In this post you will learn the different ways to backup and restore Access Database in 2007/2010/2013/2016.

Part 1: How To Back Up Access Data For Protection

Backup access database

  • Maintaining Regular Backups
  • Back Up A Database
  • Through Backing Up A Split Database
  • By Back Up A Back-End Database
  • Back up a front-end database

Way 1# Maintaining Regular Backups

As per to the type of database, access database backup should be done in two situations. And also keep a note that before backup, you should know the right time to backup database.

The right time to make a backup copy of access database:

  • When the database is active and the data is updated or changed on regular interval, then create the schedule backup of the database.
  • When you try to make changes by any action query which may change or delete data, then it become important to create a backup. Or else any changes updated by the query cannot be recovered by using Undo.
  • When the database is used by multiple users, it is recommended that you must create a backup after a design modification.

The following is on how to back up desktop database and not the Access apps.

Way 2# Back Up A Database

Step 1 – Open any Access database for which you want to make a backup.

Step 2 – Click File tab, and select Save.

Step 3 – From the right, under File Types, select Save Database As.

Step 4 – Now go to Advanced, and select Back Up Database. Click Save As.

Step 5 – In Save As window, select a location and give name to the File for backup of database. Click Save.

Way 3# Through Backing Up A Split Database

Splitting the database typically contains two database files:

  1. Back-end
  2. Front-end

Backend contains links to the table in the back-end database, queries, forms, reports, and other database objects.  The entire data get stored in the back-end database. Whereas, the front-end contains all the user interfaces objects like queries, forms and reports.

It’s a time taking procedure to back up the front-end and back-end of the database. Back-end database contains the entire data. So it’s important to keep regular backup of it.

Also Read:

Top 10 Smart Ways To Prevent Access Database Corruption

How To Share An Access Database On Network For Multi-User Access

Keep a backup of front end database when you make any changes in the access database design. Each users of the front-end database can make arbitrary design changes. So, it will be better that the user make their own backup copies of front-end database.

Way 4#By Back Up A Back-End Database

Back Up A Back-End Database

Give notifications to the users before starting the backup process as running the backup process needs exclusive access to the database file. This might restricts the user to use the back-end database while the backup process is running.

Steps To Backup Back-End Database:

  1. Open the back-end database
  2. After then tap to the Open Other FilesComputer > Browse, and then make selection for the back-end database file which you need to back up.
  3. Hit the arrow which is next to Open, and then tap to the Open Exclusive option.

Steps To Backup Back-End Database

  1. Click File, and then click Save As.
  2. Under File Types, click Save Database As.
  3. Under Advanced, click Back Up Database, and then click Save As.
  4. In the File name box, from the Save As dialog box, review the name for your database backup.
  5. The default name contains both the name of original database file and the date on which you make the backup. But later you can change the name if you need.
  6. From the save as dialog box, make selection for the location in which you wants to save the copy of the back-end data base and then click to the save option.

Way 5#Back Up A Front-End Database

Back-up the front –end database after making the design changes, just leave the database open right immediately after the changing its design. After then follow the way no 2 i.e back up a database, from the step 2.

Part 2: How To Restore Data From Access Database Backup

Restore Data From Access Database Backup

Now it’s time to learn how to restore the access database objects either using the  backup or without the backup.

Way 1#Restore Data Using Backup

In order to restore MS Access database from backup, simply choose good copy and paste it where you want to replace existing Access database with backup. While you restore database with the backup you basically replace the corrupted or damaged database.

Way 2#Restore Part Of A Database

Restore Part Of A Database

For restoring the database objects, just import the object from the backup into the database that already contains the object that you needs to restore. Through this procedure you can restore more than one object at a time.

  1. First of all open the database that you need to restore an object.
  2. For restoring the missing object like accidentally deleted table, skip to step 3. But if you want to replace an object which has a bad or missing data or has stopped working then you must follow these steps.
    • To restore the current object —

For example: to compare it with restored version after you restore. You need to rename the object before restoring it.  Suppose you want to restore a damaged Form having name Checkout then you can assign the name of the damaged form to Checkout_bad.

  • Just delete the object that you wish to replace.
  1. From the External Data tab, in the Import group, tap to the Access.
  2. Now from the Get External Data dialog box, hit the Browse option to locate the backup database.
  3. Tap to the Import tables, reports, macros, queries, forms and modules into the current database, and then hit the OK option.
  4. Now in the Import Objects dialog box, hit the tab that corresponds to the type of objects which you need to restore. e.g.:  In case of restoring the table, just click to Tables tab.
  1. To select the object just make a click on it.
  2. To restore more objects, just repeat the steps 6 and 7 until you select all the objects that you want to restore.
  3. If you need to make adjustments to the import options. In the Import Objects dialog box, tap to the Options button to take a review of these options right before the importation of your objects.
  4. After completing the selection procedure of your objects and setting options, click ok to restore the objects.

Way 3# Restoration Of MS Access Data Without Backup

Restoration Of Data Without Backup

But what if you do not have valid and up to date backup? In such case it is recommended that you must take help of professional MS Access Repair And Recovery Tool through which you can easily repair and recover your access database from all types of corruption and errors. With the use of this tool you can just sit back and relax from the worry of losing your critical data. This tool can restore all data and database objects with all queries, table data and objects, primary key, table structure and so on. Hence, if you want your important MS Access data back then download this Access repair and recovery tool now.

How To Backup and Restore Access Database USING Recovery Tool

Step 1 – Install the software and launch it. Now select the corrupt Access file for Repairing.

1

Step 2 – The software will show you the list of searched files in a drive. Select the file that you want to repair and click on Repair button.

2

Step 3 – The repairing process will get started and you see the log report for analysis.

3

Step 4Once the repairing process completes click on “OK” button to see the preview of the file database objects.

4

Step 5 – You can now preview the repaired file.

5

Step 6 – By default the software will save the repaired file to the location where the corrupt database is saved but with a new name. You can also select different location.

6

Step 7Your saving is in process.

7

Step 8 Saving completed.

8

5 Ways To Backup And Restore Access Database In 2007/2010/2013/2016?