Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Need to recover access database with superior sol

Author  Topic 

MarshallBurns
Starting Member

1 Post

Posted - 2014-10-13 : 15:00:01
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message

Error 3112: Your access database got corrupted will not be able to show the database.

Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

LawrenceStanl
Starting Member

2 Posts

Posted - 2014-10-14 : 03:18:12
Do you happen to have a backup of your database? If so, the following the instruction:
Restore an entire database
When you restore an entire database, you replace a database file that is damaged, has data problems, or is missing altogether, with a backup of the entire database.

If the database file is missing, copy the backup to the location where the database should be.
IMPORTANT If other databases or programs have links to objects in the database that you are restoring, it is critical that you restore the database to the correct location. If you do not, links to the database objects will not work and will have to be re-created, such as by using the Linked Table Manager.

If the database file is damaged or has data problems, delete the damaged file and then replace the damaged file with the backup.

Or try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above.

For more information: http://access.erepairtools.com/

And the similar question was discussed here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/314-ms-access-mdb-ldb-database-corrupted
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-10-15 : 02:49:57
To fix this corruption from a database file, Microsoft provides a built-in repair feature called Compact and Repair Database. It is also very useful when a database file becomes large and cause MS Access performance.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-10-15 : 23:42:18
Duplicate question http://www.sqlservercentral.com/Forums/Topic1625264-131-1.aspx

P.S- Please don't post same question on different forums. Choose the best for your requirement and try to get help from there.
Go to Top of Page
   

- Advertisement -