MS Access 2000 Database Corruption and Ways to Handle It

Did you just encounter Access 2000 database corruption owing to power loss? Poor you! It is such a heart-wrenching situation, when you find that your Access database has become damaged due to a mere power off. And to think that you had updated so many things in it since morning, today! Your data backup was not even scheduled till today evening! All you have is the backup created yesterday! No? Then? Now that you have faced this problem, what next? Start all over again? Well, not really!! There are ways that can be employed by any Access database user to repair Access file, and extract all the data that he had so painstakingly collected.
Let us go through these Access database repair methods to solve the problem. But before you begin, you must ensure that you have the most recent MS Jet service pack.
First, copy the damaged mdb file. This should act as a backup. Then, ensure that the mdb file is closed, before you delete any .ldb file that might be present. After this you need to select the Compact and repair utility present in the Database utilities in Tools menu. Choose the damaged file, and enter a new name for the compacted file (you may change it back to the original name after repair) in the dialog box, before clicking ‘Save’.
Another way is to create a new empty database, and import into it all the objects (except data Access page) one after the other, from the old database. To import these pages, choose Pages, from Options, and then the New button. In the dialog box that opens, choose Existing Web page, and then OK. This needs to be followed by recreation of relationships.
In case, the above steps do not help resolve your problem, then before you plan to look at backup, and start doing the same work you have been doing since morning, you should use a third-party Access database repair tool to repair access file and recover all your data.

Tags: Access, Corruption, Database, Handle