Thursday, October 1, 2009

MS Access corruption post Spybot Running

Spybot Search and Destroy (S&D) is a program that detects and removes software bugs of almost all kinds from your computer system. The software completely scans the hard drive and repairs registry, ActiveX objects, and more. While Spybot is known for its ease of installation, excellent features, and free updates, running the program can also result in corruption of MS Access database. In such situations, the Access database becomes unmountable and the data stored in the database becomes inaccessible. To overcome such database corruption scenarios, the best way is to restore the data from an updated backup. But if in case, there is no backup available or backup falls short to restore the required data, then you will need to opt for advanced access repair application that can repair your corrupted database.

Consider a practical scenario, where you have created an MS Access database (Employee). You now download Spybot v1.5 2008 1.5/5 and when you run that program, you view that the “Employee” database has been corrupted. You are no longer able to access the records saved in “Employee” database.

Cause:

The primary cause for the inaccessibility of records is corruption of “Employee” database.

Resolution:

An ideal way to resolve the corruption and access the records saved in Employee database is by using an inbuilt repair utility known as “Compact and Repair.” To use the repair utility, you will need to follow the below steps:

1.Select Database Utilities under Tools drop down list.
2.Click Compact and Repair Database.
3.Click Compact after searching and selecting the database in the ‘Database to Compact From’ dialog box.
4.Select a new folder location for the file in the ‘Compact Database Into’ dialog box.
5.Provide a unique name to the file.
6.Click on Save.

The repair utility ensures complete repair in almost all Access database corruption scenarios. But, there are situations where the utility might fail to repair your database. In such circumstances, an ideal way is to use an advanced Access Repair software. Such access database repair applications repair the corrupted database by using powerful scanning methods. These utilities are easy-to-understand without any former technical understanding.

Access Recovery is a user-friendly Access Database Repair software that repairs Access database created in Microsoft Access 2007, 2003, XP (2002), and 2000. Designed for Windows Vista, XP, 2003, 2000 and NT operating systems, the software can restore and Repair Access database components such as tables, queries, forms, reports, macros, and modules.

No comments:

Post a Comment