Friday, July 2, 2010

Fixing 'Unexpected Error 35012' in Microsoft Access and repairing corrupt database

Microsoft Access is the most extensively used database system all over the world. The application, which integrates well with other members of the Microsoft Office suite of products, stores valuable information in an .mdb file. At times, when you try and open your Access database, you may encounter several nagging errors. Such errors are clear signs that either one or more objects in your MS Access database is corrupt. In such events of corruption, your Access database becomes inaccessible. In order to repair Access file, it becomes essential for you to rely on a third-party software.

Consider a scenario, wherein you try and open an Access database, containing your customer's details, and receive the following error message:

“Unexpected Error 35012”

As a result of the above error, you are not able to access information stored in your customer's database. In order to eliminate the above error message, you must record the possible causes first.

Cause:
The above error points towards possible presence of one or more damaged/corrupt object(s) in your Microsoft Access database. The object (s) may have got damaged due to a variety of reasons including Jet database engine errors, OS corruption or application malfunction.

Resolution:
You can observe the following troubleshooting mechanisms in order to resolve the error message and repair Access file:
  • Create a new Microsoft Access database file
  • Go to File menu>>Get External Data>>Click Import (Note: Import all database objects including tables, queries, forms etc) into the new database file
  • If you receive the same error message while importing a certain object, repeat step 2 and don't include the object and restore the damaged object from an updated backup
In case you don't have a backup to restore the damaged object or if the above steps do not help you in resolving the problem, don't worry. You must download an Access database repair utility from the Internet in order to repair corrupt objects and recover your Access database.

Such utilities are made to employ improved and sophisticated algorithms to extract information from corrupt Access database. Moreover, these tools include simple and graphical user interface which doesn't require a person to be very tech-savvy.

No comments: