Step-by-step plan to backup and restore Access Database:<\/strong><\/h2>\n- Create a regular backup plan<\/li>\n\n\n\n
- Perform Access database backup<\/li>\n\n\n\n
- Perform backup for the split – backend and frontend database<\/li>\n\n\n\n
- Restore database with the backup <\/li>\n<\/ol>
Step 1: Create a regular backup plan<\/strong><\/h3>In Microsoft Access database, some changes or mistakes are irreversible.\nFor example, using an action query to change an entry or delete a record. Such entries\ncannot be reversed by using the undo function. You need to restore Access\ndatabase from the backup or you may suffer the data loss. <\/p>
A backup plan must consist of:<\/strong><\/p>\n- Schedule for data backup (Time for regular backup and name of backup software)<\/li>\n\n\n\n
- Access Repair software<\/a> (An alternative solution to repair the Access database in the absence of the latest and healthy backup) <\/li>\n<\/ul>
Note:<\/strong> Multiple users use the same database at a given point in time. Make sure that the users have logged out of the Access database before starting the scheduled backup.<\/p>\n![\"Stellar\"](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/04\/Access-database-Repair-Approach.jpg\")
<\/figure>\n<\/div>You can try the demo version of Stellar Repair for Access <\/strong>from here:<\/p>\n![\"Stellar\"](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/04\/free-download-large.gif\")
<\/a><\/figure>\n<\/div>Step 2: Perform Access Database Backup<\/strong><\/h3>Note:<\/strong> Access database closes all objects open in the design view and saves them at the specified location with the specified name. <\/p>To perform a backup, open the Access database for which back\nup is to be performed and execute the\nfollowing steps:<\/p>
\n- Go to File <\/strong>and select Save As<\/strong><\/li>\n\n\n\n
- Under the File Types, select the option Save Database As<\/strong><\/li>\n\n\n\n
- Under Advanced<\/strong>, click Backup database<\/strong> followed by Save As<\/li>\n\n\n\n
- The Save As dialog box opens. Check the name of the database in the Filename box <\/li>\n<\/ol>
Note: The default filename is a name of the database suffixed with the date of database backup. It can be changed as per convenience.<\/p>
\n- From the Save as type list, select the format to save the database followed by clicking the Save button.<\/li>\n<\/ol>
Step 3: Perform backup for split database<\/strong><\/h3>As the name suggests, a Split\ndatabase consists of two databases:<\/p>
\n- Backend database<\/strong> – data in Tables only<\/li>\n\n\n\n
- Frontend database<\/strong> – contains links to the Tables in the backend Access database along with queries, forms, reports and other database objects<\/li>\n<\/ol>
In short, the database is in the backend, and the user interface is in the frontend database. Hence, back up for the frontend database can be done periodically, whenever there is design or interface change.
Because the backend database contains data, administrators should schedule regular backups of the backend database. And there is no need to perform the lengthy split database. <\/p>
a. Perform backup of backend database<\/u><\/strong><\/h4>The first step is to notify\nthe users to log out of the Access\nDatabase. This is because users may not\nbe able to access the database during the backup process. <\/p>
The Administrator should perform the following steps:<\/strong><\/p>\n- Start Microsoft Access and go to Open Other Files followed by Computer and then Browse<\/li>\n\n\n\n
- Select the backend database file to backup<\/li>\n\n\n\n
- Click the arrow next to open and from the drop-down menu, click Open Exclusive<\/li>\n\n\n\n
- Perform Step 1 to 5 as mentioned in “Perform Access Database Backup.” <\/li>\n<\/ol>
b. Perform backup of frontend database<\/u><\/strong><\/h4>The front-end database backup\nis performed when there is a change in the\ndesign or user interface. <\/p>
\n- Once the design is changed, leave the database open<\/li>\n\n\n\n
- Follow the steps mentioned in\nthe backend database starting step 1 to step 4 <\/li>\n<\/ol>
Save the database with the\ndefault name, having date and filename, to search with ease whenever there is a\nneed for database restoration. <\/p>
For the best results, automate the backup process by using a product that can facilitate automated backups of the file systems. These may include file server backup software or external device backup software, etc. <\/p>
Step 4: Restore database with backup<\/strong><\/h3>You need to restore the\ndatabase in case the database file is damaged, has accessibility\/connectivity\nproblems, or it is missing altogether.<\/p>
Note:<\/strong> You can restore a database from a ‘good backup\ncopy’ of the database file supposed to have database integrity and design. <\/p>Perform the following steps to restore the Access database from the backup:<\/strong><\/p>\n- Open File Explorer. Browse and select the known good copy of the Access database<\/li>\n\n\n\n
- Copy the file to the location\nof the damaged or missing database<\/li>\n\n\n\n
- Replace the existing file, when you are\nprompted<\/li>\n<\/ol>
You can also restore database\nobjects in a database, but care must be taken\nin selecting the objects to be restored.\nIf there is a choice, then it is recommended to restore\nthe whole database. <\/p>
Conclusion<\/strong><\/h2>If there is an issue with the Access database, then Admin must have a healthy and restorable copy of the data backup to restore the database. While most organizations back up their database including their Access database, these are not audited regularly, which leads to unhealthy and non-restorable copies. This may further lead to prolonged inaccessibility of important Access databases. It’s better to act fast in such situations and repair the corrupt Access database with the help of effective Access repair software like Stellar Repair for Access<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"
Step 1: Create a regular backup plan<\/strong><\/h3>In Microsoft Access database, some changes or mistakes are irreversible.\nFor example, using an action query to change an entry or delete a record. Such entries\ncannot be reversed by using the undo function. You need to restore Access\ndatabase from the backup or you may suffer the data loss. <\/p>
A backup plan must consist of:<\/strong><\/p>\n- Schedule for data backup (Time for regular backup and name of backup software)<\/li>\n\n\n\n
- Access Repair software<\/a> (An alternative solution to repair the Access database in the absence of the latest and healthy backup) <\/li>\n<\/ul>
Note:<\/strong> Multiple users use the same database at a given point in time. Make sure that the users have logged out of the Access database before starting the scheduled backup.<\/p>\n<\/figure>\n<\/div>You can try the demo version of Stellar Repair for Access <\/strong>from here:<\/p>\n<\/a><\/figure>\n<\/div>Step 2: Perform Access Database Backup<\/strong><\/h3>Note:<\/strong> Access database closes all objects open in the design view and saves them at the specified location with the specified name. <\/p>To perform a backup, open the Access database for which back\nup is to be performed and execute the\nfollowing steps:<\/p>
\n- Go to File <\/strong>and select Save As<\/strong><\/li>\n\n\n\n
- Under the File Types, select the option Save Database As<\/strong><\/li>\n\n\n\n
- Under Advanced<\/strong>, click Backup database<\/strong> followed by Save As<\/li>\n\n\n\n
- The Save As dialog box opens. Check the name of the database in the Filename box <\/li>\n<\/ol>
Note: The default filename is a name of the database suffixed with the date of database backup. It can be changed as per convenience.<\/p>
\n- From the Save as type list, select the format to save the database followed by clicking the Save button.<\/li>\n<\/ol>
Step 3: Perform backup for split database<\/strong><\/h3>As the name suggests, a Split\ndatabase consists of two databases:<\/p>
\n- Backend database<\/strong> – data in Tables only<\/li>\n\n\n\n
- Frontend database<\/strong> – contains links to the Tables in the backend Access database along with queries, forms, reports and other database objects<\/li>\n<\/ol>
In short, the database is in the backend, and the user interface is in the frontend database. Hence, back up for the frontend database can be done periodically, whenever there is design or interface change.
Because the backend database contains data, administrators should schedule regular backups of the backend database. And there is no need to perform the lengthy split database. <\/p>
a. Perform backup of backend database<\/u><\/strong><\/h4>The first step is to notify\nthe users to log out of the Access\nDatabase. This is because users may not\nbe able to access the database during the backup process. <\/p>
The Administrator should perform the following steps:<\/strong><\/p>\n- Start Microsoft Access and go to Open Other Files followed by Computer and then Browse<\/li>\n\n\n\n
- Select the backend database file to backup<\/li>\n\n\n\n
- Click the arrow next to open and from the drop-down menu, click Open Exclusive<\/li>\n\n\n\n
- Perform Step 1 to 5 as mentioned in “Perform Access Database Backup.” <\/li>\n<\/ol>
b. Perform backup of frontend database<\/u><\/strong><\/h4>The front-end database backup\nis performed when there is a change in the\ndesign or user interface. <\/p>
\n- Once the design is changed, leave the database open<\/li>\n\n\n\n
- Follow the steps mentioned in\nthe backend database starting step 1 to step 4 <\/li>\n<\/ol>
Save the database with the\ndefault name, having date and filename, to search with ease whenever there is a\nneed for database restoration. <\/p>
For the best results, automate the backup process by using a product that can facilitate automated backups of the file systems. These may include file server backup software or external device backup software, etc. <\/p>
Step 4: Restore database with backup<\/strong><\/h3>You need to restore the\ndatabase in case the database file is damaged, has accessibility\/connectivity\nproblems, or it is missing altogether.<\/p>
Note:<\/strong> You can restore a database from a ‘good backup\ncopy’ of the database file supposed to have database integrity and design. <\/p>Perform the following steps to restore the Access database from the backup:<\/strong><\/p>\n- Open File Explorer. Browse and select the known good copy of the Access database<\/li>\n\n\n\n
- Copy the file to the location\nof the damaged or missing database<\/li>\n\n\n\n
- Replace the existing file, when you are\nprompted<\/li>\n<\/ol>
You can also restore database\nobjects in a database, but care must be taken\nin selecting the objects to be restored.\nIf there is a choice, then it is recommended to restore\nthe whole database. <\/p>
Conclusion<\/strong><\/h2>If there is an issue with the Access database, then Admin must have a healthy and restorable copy of the data backup to restore the database. While most organizations back up their database including their Access database, these are not audited regularly, which leads to unhealthy and non-restorable copies. This may further lead to prolonged inaccessibility of important Access databases. It’s better to act fast in such situations and repair the corrupt Access database with the help of effective Access repair software like Stellar Repair for Access<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"
- \n
- Schedule for data backup (Time for regular backup and name of backup software)<\/li>\n\n\n\n
- Access Repair software<\/a> (An alternative solution to repair the Access database in the absence of the latest and healthy backup) <\/li>\n<\/ul>
Note:<\/strong> Multiple users use the same database at a given point in time. Make sure that the users have logged out of the Access database before starting the scheduled backup.<\/p>
\n<\/figure>\n<\/div>You can try the demo version of Stellar Repair for Access <\/strong>from here:<\/p>
\n<\/a><\/figure>\n<\/div>Step 2: Perform Access Database Backup<\/strong><\/h3>
Note:<\/strong> Access database closes all objects open in the design view and saves them at the specified location with the specified name. <\/p>
To perform a backup, open the Access database for which back\nup is to be performed and execute the\nfollowing steps:<\/p>
- \n
- Go to File <\/strong>and select Save As<\/strong><\/li>\n\n\n\n
- Under the File Types, select the option Save Database As<\/strong><\/li>\n\n\n\n
- Under Advanced<\/strong>, click Backup database<\/strong> followed by Save As<\/li>\n\n\n\n
- The Save As dialog box opens. Check the name of the database in the Filename box <\/li>\n<\/ol>
Note: The default filename is a name of the database suffixed with the date of database backup. It can be changed as per convenience.<\/p>
- \n
- From the Save as type list, select the format to save the database followed by clicking the Save button.<\/li>\n<\/ol>
Step 3: Perform backup for split database<\/strong><\/h3>
As the name suggests, a Split\ndatabase consists of two databases:<\/p>
- \n
- Backend database<\/strong> – data in Tables only<\/li>\n\n\n\n
- Frontend database<\/strong> – contains links to the Tables in the backend Access database along with queries, forms, reports and other database objects<\/li>\n<\/ol>
In short, the database is in the backend, and the user interface is in the frontend database. Hence, back up for the frontend database can be done periodically, whenever there is design or interface change.
Because the backend database contains data, administrators should schedule regular backups of the backend database. And there is no need to perform the lengthy split database. <\/p>a. Perform backup of backend database<\/u><\/strong><\/h4>
The first step is to notify\nthe users to log out of the Access\nDatabase. This is because users may not\nbe able to access the database during the backup process. <\/p>
The Administrator should perform the following steps:<\/strong><\/p>
- \n
- Start Microsoft Access and go to Open Other Files followed by Computer and then Browse<\/li>\n\n\n\n
- Select the backend database file to backup<\/li>\n\n\n\n
- Click the arrow next to open and from the drop-down menu, click Open Exclusive<\/li>\n\n\n\n
- Perform Step 1 to 5 as mentioned in “Perform Access Database Backup.” <\/li>\n<\/ol>
b. Perform backup of frontend database<\/u><\/strong><\/h4>
The front-end database backup\nis performed when there is a change in the\ndesign or user interface. <\/p>
- \n
- Once the design is changed, leave the database open<\/li>\n\n\n\n
- Follow the steps mentioned in\nthe backend database starting step 1 to step 4 <\/li>\n<\/ol>
Save the database with the\ndefault name, having date and filename, to search with ease whenever there is a\nneed for database restoration. <\/p>
For the best results, automate the backup process by using a product that can facilitate automated backups of the file systems. These may include file server backup software or external device backup software, etc. <\/p>
Step 4: Restore database with backup<\/strong><\/h3>
You need to restore the\ndatabase in case the database file is damaged, has accessibility\/connectivity\nproblems, or it is missing altogether.<\/p>
Note:<\/strong> You can restore a database from a ‘good backup\ncopy’ of the database file supposed to have database integrity and design. <\/p>
Perform the following steps to restore the Access database from the backup:<\/strong><\/p>
- \n
- Open File Explorer. Browse and select the known good copy of the Access database<\/li>\n\n\n\n
- Copy the file to the location\nof the damaged or missing database<\/li>\n\n\n\n
- Replace the existing file, when you are\nprompted<\/li>\n<\/ol>
You can also restore database\nobjects in a database, but care must be taken\nin selecting the objects to be restored.\nIf there is a choice, then it is recommended to restore\nthe whole database. <\/p>
Conclusion<\/strong><\/h2>
If there is an issue with the Access database, then Admin must have a healthy and restorable copy of the data backup to restore the database. While most organizations back up their database including their Access database, these are not audited regularly, which leads to unhealthy and non-restorable copies. This may further lead to prolonged inaccessibility of important Access databases. It’s better to act fast in such situations and repair the corrupt Access database with the help of effective Access repair software like Stellar Repair for Access<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"
- Frontend database<\/strong> – contains links to the Tables in the backend Access database along with queries, forms, reports and other database objects<\/li>\n<\/ol>
- Backend database<\/strong> – data in Tables only<\/li>\n\n\n\n
- Under the File Types, select the option Save Database As<\/strong><\/li>\n\n\n\n
- Go to File <\/strong>and select Save As<\/strong><\/li>\n\n\n\n