How to backup & restore MS Access 2010 database?

-
Today in world of computers, data is everything and if data is lost, everything is lost. So taking regular backup of data is very important. In case of disaster, you can easily restore your data from backup but if there is no backup available then you may have to use the time consuming and expensive recovery process. You should also plan your backups i.e. how frequently database must be backed up, how much copies of database you need to create etc. If data in your database changes frequently then you should backup your database regularly. In MS Access 2010, there is an inbuilt command for taking backup of database. So let's discuss how to backup MS Access 2010. 

How to backup MS Access database?
Following are the steps to create a backup:
  1. First open the database.
  2. Go to File-> Save & Publish.
  3. Click Advanced tab.
  4. In the Save Database As dialog box, click Backup database.
  5. In the Save As dialog box, you can change the name of default database if you want.
If your database has been split in two parts i.e. font-end and back-end then it is important to backup both database independently. Since back-end database contains most of your data so it is recommended to take regular backup of it. Each user has its own copy of front-end database so it is up to the user to backup database according to how frequently he changes it.

How to backup a back-end database?
When you try to backup your back-end database, make sure no body is using it. Following are the steps to backup a back-end database:
  1. Start Access, click Open.
  2. Select the back-end database that you want to backup.
  3. Click the arrow next to Open and select Open Exclusive.
  4. Now go to File-> Save & publish.
  5. In the Save Database As dialog box, click Backup database.
  6. In the Save As dialog box, you can change the name of default database if you want.
How to backup a font-end database?
Steps for font-end database backup are same as How to backup MS Access database?

How to restore MS Access database?
You can restore database only if you have a valid backup copy of your database. While restoring database you basically replace a database file that is corrupted with a valid and up to date backup copy.
  1. Open Windows Explorer and select the backup copy of database.
  2. Now copy the backup copy to the location where you corrupted file is store.

Comments

  1. Holton26 February 2017 at 10:26

    Good writting in the database disaster recovery plan, Please clarify that it works only with Access 2010
    Following are the steps to create a backup:
    First open the database.
    Go to File-> Save & Publish.
    Click Advanced tab.
    In the Save Database As dialog box, click Backup database.
    In the Save As dialog box, you can change the name of default database if you want.

    Will it work with all platform

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more

How to disable “Enable Editing” option in MS Word 2010?

-
Image
Have you ever worked on Word 2010? If yes then you might have noticed that whenever you open any document in Word 2010 and try to edit it, you just can't. To edit or save a document you have to click on the yellow bar that contains Enable Editing button. Once you click on that button then you can edit your document. This is basically a new security feature in Word 2010. The yellow bar on which Enable Editing button appears is known as Protected View. This feature helps in protecting your computer from any virus or any other malicious activity. Sometime, it's really frustrating to click on that yellow button whenever you open a document. If you know your files are safe and you don't need this security feature to appear then disable it.
Read more