{"id":2475,"date":"2015-04-14T08:25:15","date_gmt":"2015-04-14T08:25:15","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=2475"},"modified":"2023-04-15T08:51:15","modified_gmt":"2023-04-15T08:51:15","slug":"how-to-backup-access-database-and-restore-data-or-objects","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/how-to-backup-access-database-and-restore-data-or-objects\/","title":{"rendered":"How to Backup Access Database and Restore Data or Objects"},"content":{"rendered":"<p>In order to protect Access data, not only<a href=\"https:\/\/www.isunshare.com\/access-password\/how-to-encrypt-and-decrypt-access-database.html\"> encrypt access database<\/a>, <strong>backup Access database<\/strong> also becomes important for Microsoft Access users. So that when data or objects in access database are changed or lost, corrupted or missing, or database design is changed, they can be restored completely. See how to <a href=\"https:\/\/www.isunshare.com\/blog\/how-to-backup-access-database-and-restore-data-or-objects\/\">backup and restore access database<\/a>?<\/p>\n<ul>\n<li><a href=\"#section1\">Section 1: How to back up access data for protection<\/a><\/li>\n<li><a href=\"#section2\">Section 2: How to restore data or objects from Access database backup<\/a><\/li>\n<\/ul>\n<h2 id=\"section1\">Section 1: How to back up access data for protection<\/h2>\n<p>According to database type, <strong>access database backup<\/strong> should be introduced in two situations. And before backup, we should know the right time to backup database.<\/p>\n<p>When we should make a backup copy of access database?<\/p>\n<ol>\n<li>When you prepare to run any action query, which will change or delete data, please consider making a backup. Otherwise, any values that were updated by the query cannot be restored by using Undo.<\/li>\n<li>When the database is active and the data is frequently changed, create a schedule to regularly backup the database.<\/li>\n<li>When the database has multiple users, create a backup copy of the database after a design change.<\/li>\n<\/ol>\n<p>The following applies to <strong>back up desktop database<\/strong>, but not Access apps.<\/p>\n<h3>S1: How to make a regular backup copy of access database?<\/h3>\n<p>1. Open the database for which you want to create a backup.<\/p>\n<p>Now database is open in Access 2010.<\/p>\n<p>2. Click <strong>File<\/strong> tab, and choose <strong>Save &amp; Publish<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"473\" class=\"alignnone size-full wp-image-2483\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-database.png\" alt=\"backup access database\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-database.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-database-300x237.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>3. In the right, under <strong>File Types<\/strong>, choose <strong>Save Database As<\/strong>.<\/p>\n<p>4. Under <strong>Save Database As<\/strong> option, move to <strong>Advanced<\/strong>, and select <strong>Back Up Database<\/strong>. Click <strong>Save As<\/strong>.<\/p>\n<p>5. In Save As window, specify a location and File name for backup of database. Click <strong>Save<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/save-access-database-backup.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"418\" class=\"alignnone size-full wp-image-2484\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/save-access-database-backup.png\" alt=\"save access database backup\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/save-access-database-backup.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/save-access-database-backup-300x209.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>Note: Back up database in Access 2013 is the same as in Access 2010 like above.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-2013-database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"346\" class=\"alignnone size-full wp-image-2485\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-2013-database.png\" alt=\"backup access 2013 database \" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-2013-database.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/backup-access-2013-database-300x173.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h3>S2: How to backup split database<\/h3>\n<p>When your database that contains linked tables is an Access database, what you should back up is a split database. Such split database consists of two database files, a back-end database and front-end database. Front-end database is the database which contains links to the tables in the back-end database.<\/p>\n<p>So, if you want to <strong>back up split database<\/strong>, besides making a backup copy of back-end database, you have to back up front-end database after design changes.<\/p>\n<p>It is worth to mention that the process to back up back-end database is similar to backup database like above except following differences. Therefore, if you have any questions about split database backup, please pay attention to the differences and follow the backup process in <a href=\"#section1\"><em>how to make a regular backup copy of access database<\/em><\/a>.<\/p>\n<p>1. The way to open back-end database in Access<\/p>\n<p>When you open back-end database file in Access, you should choose &#8220;Open Exclusive&#8221; mode in Open window.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/open-back-end-database-to-backup.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"419\" class=\"alignnone size-full wp-image-2486\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/open-back-end-database-to-backup.png\" alt=\"open back-end database to backup split database\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/open-back-end-database-to-backup.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/open-back-end-database-to-backup-300x210.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>2. The way to name backup file<\/p>\n<p>In the backup save as window, the backup file name is default set as this format, name of the original database file and the date that you make the backup. Let it be. So that when you want to restore data or objects from a backup, you can easily choose a backup according to the backup name and date.<\/p>\n<h2 id=\"section2\">Section 2: How to restore data or objects from Access database backup<\/h2>\n<p>If you want to restore data from Access database backup, just choose a known good copy and paste it where Access database saves which you want to replace with backup.<\/p>\n<p>If you want to restore objects from Access database backup, you should make sure whether you want to use objects in backup to replace objects that ones in Access database which contains bad or missing data or has stopped working correctly, or you want to restore missing objects.<\/p>\n<p>When you want to preserve bad objects and restore right objects, do like following.<\/p>\n<p>Compare it with the restored version after you restore, rename the object before you restore it. For example, if you want to restore a damaged form named Checkin, you can rename the damaged form <strong>Checkin_bad<\/strong>. Delete the object that you want to replace.<\/p>\n<p>When you want to restore missing objects from backup, it would be like <a href=\"http:\/\/isunshare.blogspot.com\/2015\/03\/how-to-import-existing-access-or-sql-database-into-access.html\">importing database into Access database<\/a>.<\/p>\n<p><strong>\u00a0Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-open-access-database-without-access-privileges\/\">How to Open Access Database without Access Privileges<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/3-ways-to-create-access-database\/\">3 Ways to Create Access 2007-2013 Database<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/mdb-password-recovery-after-password-forgot-or-lost\/\">MDB\/ACCDB Password Recovery after Password Forgot or Lost<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-disable-iphone-backup-forgotten-password\/\">How to Disable iPhone Backup Forgotten Password <\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-choose-backup-method-itunes-vs-icloud\/\">How to Choose Backup Method | iTunes VS iCloud<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In order to protect Access data, not only encrypt access database, backup Access database also becomes important for&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126295,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2475","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=2475"}],"version-history":[{"count":4,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2475\/revisions"}],"predecessor-version":[{"id":6466,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2475\/revisions\/6466"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126295"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=2475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=2475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=2475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}