ArticlesBase.com - Free Articles Directory
Free Online Articles Directory
26.07.2008 Sign In Register Hello Guest
Email:
Password:
Remember Me 
forgot your password?


Recover Data From Corrupt Access Database

Author: Neha Gupta Author Ranking Blue | Posted: 09-08-2007 | Comments: 0 | Views: 24 | Rating:  (50) Article Popularity - Green (?) Got a Question? Ask.
Sign Up Now!

Microsoft Access is the widely used software to create databases, reports, store information, macros, queries, tables, share information, forms, and modules.

A database is created to collect and organize information. This information can be about people, orders, products, employees, budget and so on. As the storage space in the database maximizes, increases the chances of corruptions.

A database file can get corrupt, damaged due to many reasons, the saved tables, information, queries can get damaged due to the following reasons:

1.If a query, report or form is being run
2.If a record is updated or
3.Any damaged table

When these kinds of situations happen, the following error messages are displayed which signify such kind of corruptions:

For table corruptions: “#Error”, “Jet has stopped the process because you and another user
attempted to change the same data at the same time”

4.If you use Jetcomp to compact the database, the following error is displayed; “Records cannot be read, no read permissions on MyDatabase.”

In cases of damaged or corrupt tables, you can try the following method to recover data from the corrupt access database file:

1.Copy the table

2.Paste the structure of the damaged database table to a new one.

3.Simultaneously open the original and copy of the database.

4.On the damaged table, select ‘Datasheet View’, then select the entire record by clicking on the blank buttons to the left of each record. Now, copy the records from the damaged database table.

5.After switching to the new table, line up the pointer at the same location as it was in the damaged database table. Now, click Paste.

6.You can test the table after each copy & paste process.

7.Repeat the first 4 to 6 using single records or smaller groups records. You might get an error while testing the records, and replace any data which cannot be moved to the new table.

8.When all the records have been moved to the new table, create a new database file with different name.

9.Now, import table and other un-damaged objects into new database.

10.As the table import process gets completed, Exit the program.

11.Rename the corrupt database file with a new name and move it to a new location. Remove the .Idb file of the damaged database (if it exists) and move the new database to new location.

12.Now, rename the new database file with the damaged database file name.

Following these steps you can eventually recover data from the damaged MS Access database files. But if in case, you are unable to recover data from corrupt Access database then try the Corrupt Access database repair software or an Access Recovery software available for free demo download.

Rate this Article: Current: 0 / 5 stars - 0 vote(s).

Article Source: http://www.articlesbase.com/data-recovery-articles/recover-data-from-corrupt-access-database-196123.html

Print this Article Print article   Email to a Friend Send to friend   Publish this Article on your Website Publish this Article   Send Author Feedback Author feedback  
About the Author:

Neha Gupta is a technical writer for Nucleus Data Recovery - the provider of best data recovery software and disk recovery tools to recover deleted files.

Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free!

Article Comments

Comment on this article Comment on this article
Your Name
Your Email:
Comment Body
Enter Validation Code: Captcha


Related Articles

Tips to Prevent Ms Access Corruptions
By: Neha Gupta | 03/01/2007 | Data Recovery
Here are some tips and measures to prevent MS Access database corruptions. The access recovery measures can prove beneficial in the cases of access database corruptions due to virus attacks, media corruptions, unexpected system shutdowns and so on.

Recovery From Corrupted Ms Access Table
By: Andrew Watson | 27/02/2008 | Data Recovery
In this situation, to repair your corrupted database, you need to repair it using third party software. These third party software are known as Access Repair software. These are the software specially designed to repair damaged or corrupted Access database, whatever the reason of database corruption.

Got a Question? Ask.

Ask the community a question about this article:

Q&A Powered by:
Powered by Yedda 

Latest Data Recovery Articles

Guaranteed Password Recovery - or Your Money Back!
By: Andrew Hamilton | 24/07/2008
Recover passwords to multiple applications, most important Word and Excel documents can be recovered within just a minute. with a Complete Satisfaction Guarantee. If you are unable to recover your password in less than 36 hours, LastBit will refund your purchase price in full.

Data Recovery Made Easy for Windows Users
By: Eugine Kharinskiy | 24/07/2008
SoftAmbulance Uneraser is simple, reliable and bullet-proof. Even if you tried to recover with free undelete tools and they messed up the disk, we can still recover your files.

Technology & Website Strategies to the Next Level
By: Kanwaljit Kaur | 20/07/2008
Many companies agree that a website is a very strong sales vehicle resulting in increased sales. However, after investing a substantial amount of money in building an elaborate Website, the disappointment settles in when they begin to realize that their website does not produce the results they hoped for, and that it does not match their needs and expectations.

Recovery Word Files
By: Recovery Toolbox Inc | 18/07/2008
Software tool for a repairing corrupted Microsoft Word *.doc, *.docx, *.dot, *.dotx files and Rich Text *.rtf files.

Mmc Data Recovery
By: Brian Link | 17/07/2008
Almost everyone has a digital camera with a Multimedia Card (MMC) inside to store their photographs. Of course, as with all data storage devices, an MMC can suffer from data loss and require data recovery.

Mac Data Recovery
By: Brian Link | 17/07/2008
Even Apple's highly-touted Mac line of computers can suffer from data loss. Even though Mac owners would be afraid to admit that it can happen you should be prepared to learn about Mac data recovery.

Offsite Data Backup is Necessary
By: Brian Link | 16/07/2008
Offsite data backup is an increasingly popular way to provide your home or business with a safe and reliable way to keep your data safe. These backup facilities offer more protection against data loss than you can usually provide for yourself.

Data Recovery Services
By: Brian Link | 16/07/2008
Data recovery services are a necessary evil in today's technology environments. With data loss occurring each day, the demand for quality data recovery services is rising to try and meet the demand.

More from Neha Gupta

How is Ms Access Database Useful?
By: Neha Gupta | 12/02/2008 | Databases
Read about MS Access; what MS Access database how is it useful is and what are the advantages of using Access database. Article explains how access file repair becomes useful if your access database gets corrupt or damaged.

Paradox Database Repair
By: Neha Gupta | 05/05/2007 | Data Recovery
What is paradox database? What is it used for and what if the paradox database gets corrupt or you cannot access the paradox database file. Paradox recovery software can solve your problems. Read to know more…

Word Recovery Software - Recover your Word Data
By: Neha Gupta | 03/05/2007 | Data Recovery
I deleted my MS Word files and then realized the importance of those files. Searched on internet and found word recovery software to recover the deleted .doc files.

Zip File Recovery
By: Neha Gupta | 23/04/2007 | Data Recovery
What is WinZip? Why is WinZip used? How the WinZip software proves helpful while transferring data? All these questions are answered in the following article.

Types of Backups
By: Neha Gupta | 20/04/2007 | Data Recovery
There are five types of backups offered by windows backup utility. These different backup types prove helpful to different individual according to the requirement. Backups can get corrupt, damage, inaccessible due to virus attacks, file deletion etc. The MS backup recovery software helps to recover the lost, inaccessible backups corrupted due to different reasons.

Tape Data Recovery Software
By: Neha Gupta | 18/04/2007 | Data Recovery
Tapes are used to store large amount of data, but the tape media can get corrupt due to unknown reasons. The inaccessible data is then recovered through Physical and Logical data recovery techniques.

How to Create Backups
By: Neha Gupta | 17/03/2007 | Data Recovery
Heard from many people about backing up data but don’t know how to do it. Read the article to know the steps of creating backups of your important data, files and folders and protect data from getting corrupt.

Why My Office Files Do not Open?
By: Neha Gupta | 12/03/2007 | Data Recovery
Have you ever wondered why is your office file not working or is not opening up with its respective program. Read on to know why all this happens and how can you correct this on your own.

Article Categories






Give Feedback

Sign up for our email newsletter

Receive updates, enter your email below