Sunday, February 14, 2010

"Unexpected Error 35012" When You Open a Database.

We always store office work in form of database. For maintaining and creating database, MS access is best software utility. As it is easy to use but sometimes when we try to open an existing MS Access Database, you may get an error message:

“Unexpected error 35012”

Due to this error your database closes unexpectedly. You face this error due to the corruption in the Microsoft Access Database or mdb file. These corrupted objects may include one or more database forms of reports.

As Microsoft has provided compact and repair utility to repair access database and several other utility is form of patch to resolve this problem such as jet compact utility. One more method is there to repair the corrupt database i.e import the corrupted .mdb file or object in a new file. For importing corrupted database, follow following steps:

* Create a new Access database
* In file menu, select Get External Data option
* Select Import from Get External Data
* Select all the database objects in the file and import in newly created database

If you again face "Unexpected error 35012" when you import a specific object, try the 2nd step again. If you fail to import this time also, you will need to restore the corrupt object from backup.

But it helps only when your database is less corrupted. If it is critically corrupted then compact and repair utility or jet compact utility doesn’t help you. Even you can’t import database. In case if you fail to import the database and you don’t have any backup, then you can’t repair your database without using 3rd party access repair tools. In these situations, your entire database may become inaccessible. Access recovery softwares are the powerful data recovery programs that can search and locate your corrupted access database and can repair them.

No comments:

Post a Comment