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.

by: Golvin

POST COMMENT

How To Prevent Destruction Of Data At A Crime Scene Hf Sd Rfid Reader Characterizes Seamless Data Transmission Claim Your Money With A Judgement Recovery Agency Tummy Tuck Recovery Time Why Go For Dedicated Web Hosting & Data Centre Colocation India? Data on Contracts for Difference How To Do Well In Gmat Data Sufficiency Data Entry work No Registration fees Access Database Got Corrupt After Using Dao Excel Recovery Solutions When Workbook Is Damaged How to deal with data loss from hard drive Precisely what to Watch for in a Miami Rehab and Substance Recovery Center Microsoft Access Database, A Tool To Simplify The Managerial Tasks