In this section, we will focus on creating a plan to backup the MS Access database and steps to restore the database.
Maintain Regular Access Database Backup:
Maintaining regular backups is the best strategy to counter data loss arising due to system failure. Also, certain changes or mistakes are irreversible, so if you backup the MS Access database, it will save you from a lot of inconveniences. For example, when you perform an action query to delete records or change data, the updated values cannot be restored by the Undo function.
Keep the following guidelines in mind, while deciding how often you should backup your MS Access database:
If the database is an archive, or it is mostly used for reference
purposes and rarely changes, it is sufficient to create backups only
when the design or data is changed.
If the database is active and prone to frequent data changes, create a schedule for regular backup of the database.
If the database has multiple users, create a backup copy of the database after a design change.
Note: If the database has several users before you perform a backup make sure that all users have logged out so that all changes to the data are saved.
Backup MS Access Database
When you create a backup for the MS Access database, Access saves and closes objects that are open in the Design view and saves a copy of the database file with a name and location as specified by you. Open the MS Access database for which you wish to create a backup and follow the instructions given below :
- Click File>Save As.
- Under File Types, click Save Database As.
- Under Advanced, click Back Up Database, and then click Save As.
- In the Save As dialog box, review the name of your database backup in the File name box.
- From the Save As Type list, select the file type in which you want the backup database to be saved as and then click Save.
Perform Backup for Split Database
As the name implies, a Split database consists of two databases :
- Backend Database: which contains data in tables only.
- Frontend Database: which contains links to the tables in the backend database along with queries, forms, reports, and other database objects.
All the data is stored in the backend database while the user interface is kept in the frontend database. Since the backend database contains all the data, it is important to schedule regular backups for it. On the other hand, you can perform a backup of the frontend database whenever there is a change in design or interface. This way you can save yourself from the inconvenience of performing a lengthy split database.
Create a Backup of Backend Database
Before you start the backup process, notify the users to log out as they will not be able to access the database during the backup process. To back up the backend database, follow the instructions given below:
- To open the backend database only, start MS Access on your computer.
- Go to Open Other Files > Computer > Browse and then select the backend database file you want to backup.
- Click the arrow next to Open, and then click Open Exclusive.
- Click File > Save As.
- Under File Types, click Save Database As.
- Under Advanced, click Backup Database As and then click save as.
- In the Save As dialog box, check the name of the database in the File name box.
- Select a location in the Save As dialog box to save the backup copy of your backend database and then click Save.
Create a Backup of Frontend Database
Backup for a Frontend database is performed when there is a change in design or user interface. Follow the instructions given below to perform backup for frontend database:
- Leave the database open immediately after a design change.
- Follow the steps mentioned in the section Backup MS Access Database starting at step 2.
Save the database with a default name, having date and filename, so that you can easily search it whenever there is any requirement for database restoration.
Restore MS Access Database
A backup is considered to be a “known good copy “– a copy of which you are sure of the data integrity and design. You need to restore the MS Access database in case a database file is damaged, has accessibility or connectivity issues, or is missing altogether. You can restore a database if you have a good backup copy. To restore the MS Access database from a backup, follow the steps given below:
- Open File Explorer and browse and select the known good copy of the database.
- Copy the file to the location where the damaged or missing database should be replaced.
- Replace the existing file, when prompted to do so.
Precautions to keep in mind during the Backup and Restore MS Access Database Process
- After the backup MS Access Database process is complete, cross-check if your database file is properly backed up or not.
- If the backup copy contains sensitive information, it is better to keep it encrypted.
- Make a copy of the backup database items in some off-site location on a regular basis.
Also, to know more about backup services like QuickBooks Desktop Cloud Backup or Backup Email in Office 365 visit Apps4rent.