Microsoft Access is one of the widely used database software for creating tables, queries, reports, macros, forms and modules. It is great for storing and organizing information. The information you store in the database could be about people, products, orders, budget, employees etc. With the space for storage increases in the database, it also makes chances for corruption bigger.

There are many reasons why your database, its information, queries and tables can get corrupted or damaged. Some of the reasons your database can get corrupted is when a form, report or query is being run, when the record is updated or if there is a damaged table.

There are different error messages that can be displayed when these situation occur and which signify various types of corruption. In case of the table corruption this kind of error is displayed, for example, jet has stopped due to the attempt of changing the same date and at the same time by several users. If you utilize Jetcomp to compact your database, you could see such an error as “Records cannot be read”.

There are methods for recovering data from the corrupt and damaged Access database files.
The first thing what you should do is to copy the table. Then you should paste the structure of the corrupt database table into a newly created one. Then open the original and the copy of the database simultaneously. Go to the damaged table and select the Datasheet View. Then you should select the entire record clicking on the blank button on the left. The next step is to copy the records from the damaged database table. When you go to the new table, put the pointer at the same place as it was in the corrupted table and then click paste.

Then you can test your table after every copy and paste routine. After you have transferred all the records to the new table you can create a new database file with a different name and import all the uncorrupted objects into that new database. Now you can exit the program. The corrupt database file should be renamed and moved to a new location. If there is an .Idb file in the damaged database, you should remove it and place the new database to the new location.

If you follow these steps, you will be able to recover data from the corrupt and damaged Microsoft Access database files. But if you feel like you cannot do it by yourself, there is different software online available for download that will help you repair and recover your corrupted database files. It is very important to be able to recover your damaged data in your database because you will have the opportunity to save a lot of information this way.

All you need about microsoft access database: great training information, all sorts of business products (customized for your needs), special microsoft access database blog with tips and tricks about MA databases.

All this and more from a trustworthy UK based company which majors at microsoft access database and is assisting clients all over the world.