Wednesday, June 27, 2012

Top 6 Reasons for Access database Corruption & Recovery Methods

Are you using MS Access database to store your data or records? Here you will read about top 6 reasons for Access database corruption & its recovery actions. I think “prevention is better than cure”. It will save your priceless data from corruption that results save money & time. The reasons are:
  1. Bad User Action
  2. Power Supply Failure
  3. Hardware Problem
  4. Software Mall-function
  5. Disk Space Issue
  6. Microsoft Service Pack Issue
Bad User Activity: Turn off your computer or machine without proper closing Access database.
Action: Try to hire trained users who know the result of this and always watch which users have corrupt computer.

Power Supply Failure: It can happen due to several reasons like spark, outage, bad wire and many more.
Action: Make sure your UPS machine or other secondary power supplier is working fine. 

Hardware Problem: In a survey, it is find that 95% of Access database corruption happens due to hardware problem.
Action: Troubleshoot and replace faulty hardware. 

Software Mall-function: Any crash application can crashed your other application like Access database.
Action: Try to remove any unnecessary software from your computer and make sure you have updated latest services pack.

Disk Space Issue: Unavailable space for temp files & folder in your hard drive.
Action: Make sure that your hard drive has hundreds of free disk space.

Microsoft Service Pack Issue: Working on the different service pack may cause of corruption and you may loss some data from your database.
Action: Download & update latest service pack from Microsoft official website.

Note: I hope that all the above described prevention methods are enough to prevent your MS Access database from corruption but in case you will still face corruption then here are some Access recovery tips for you.

Access Recovery Tips: First of all make a copy of your corrupt database before overwriting anything. Now try build-in-repair utility to repair your corrupt database.

For MS Access 2010: Go to the tools ribbon and click on the “Compact & Repair” database. 

For MS Access 2007: Click on your Office button, go with manage and select “Compact & Repair” database.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...