A corrupt table in MS Access means lost time and data. It can lead to a loss of revenue or even employment. Learn how you might be able to recover most of the data when the worst happens.
by Susan Sales Harkins
September 18, 2009
f you use MS Access to store and manipulate data, you know that corruption happens. While it may not be an absolute certainly, Access is more susceptible to corruption than other databases. Because corruption in Access is usually the result of improper use, you can largely prevent it by simply avoiding the improper use practices. When corruption does occur though, the cause will be irrelevant—you'll just want to recover as much data as possible.
Corruption comes in many forms, so it stands to reason that there are a number of ways to recover data. You could spend a lot of time trying one technique after another until something finally works, but pinpointing the actual type of corruption first will make the recovery more efficient. If the corruption is bad data, for example, you can usually recover almost all of the data. You will almost always have to re-enter the bad data, however. This article explains how to perform this data recovery when the worst happens.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
f you use MS Access to store and manipulate data, you know that corruption happens. While it may not be an absolute certainly, Access is more susceptible to corruption than other databases. Because corruption in Access is usually the result of improper use, you can largely prevent it by simply avoiding the improper use practices. When corruption does occur though, the cause will be irrelevant—you'll just want to recover as much data as possible.
