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. 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

How to resolve MS Access error “Cannot find the database you specified”?

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