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:
- Bad User Action
- Power Supply Failure
- Hardware Problem
- Software Mall-function
- Disk Space Issue
- 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