I am a database administrator and maintain the database in well mannered way. But suddenly i got corruption in my access database 2013 and lost crucial files. I want to know to fix corrupt access files and how to restore ms access database on system with old originality?

First of all, you can try the build-in "Compact and Repair" command in Access to repair your corrupt database, you can get more detailed info at:

http://office.microsoft.com/en-us/access-help/compact-and-repair-a-database-HA010341740.aspx
http://databases.about.com/od/tutorials/fl/How-To-Compact-and-Repair-an-Access-2013-Database.htm

If the above method does not work, then you can try third-party Access data recovery tools, such as DataNumen Access Repair at:

http://www.datanumen.com/access-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try before you buy.

If you prefer to use a service instead of a product, then you can use Everything access data recovery service at:

http://www.everythingaccess.com/

I know Wayne in person and he will only charge you if you are satisfied with the recovery result.

Good luck!

• Proposed as answer by chcw Thursday, May 22, 2014 9:05 PM

First of all, you can try the build-in "Compact and Repair" command in Access to repair your corrupt database, you can get more detailed info at:

http://office.microsoft.com/en-us/access-help/compact-and-repair-a-database-HA010341740.aspx
http://databases.about.com/od/tutorials/fl/How-To-Compact-and-Repair-an-Access-2013-Database.htm

If the above method does not work, then you can try third-party Access data recovery tools, such as DataNumen Access Repair at:

http://www.datanumen.com/access-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try before you buy.

If you prefer to use a service instead of a product, then you can use Everything access data recovery service at:

http://www.everythingaccess.com/

I know Wayne in person and he will only charge you if you are satisfied with the recovery result.

Good luck!

• Proposed as answer by chcw Thursday, May 22, 2014 9:05 PM

First of all, you can try the build-in "Compact and Repair" command in Access to repair your corrupt database, you can get more detailed info at:

http://office.microsoft.com/en-us/access-help/compact-and-repair-a-database-HA010341740.aspx
http://databases.about.com/od/tutorials/fl/How-To-Compact-and-Repair-an-Access-2013-Database.htm

If the above method does not work, then you can try third-party Access data recovery tools, such as DataNumen Access Repair at:

http://www.datanumen.com/access-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try before you buy.

If you prefer to use a service instead of a product, then you can use Everything access data recovery service at:

http://www.everythingaccess.com/

I know Wayne in person and he will only charge you if you are satisfied with the recovery result.

Good luck!

• Proposed as answer by chcw Thursday, May 22, 2014 9:05 PM

You can try to Compact and Repair your corrupt database. This is the very first solution you must try. If it doesn't work, this means the database is severely corrupted and can't be fixed by MS Access. In such situation you can use some third-party MS Access repair or recovery software. If you are looking for an effective and relevant solution, I will suggest you to use Recovery Toolbox for Access. It will resolve any type of corruption error from your database file and restore your maximum possible data to a new database file. Download its free demo version to see preview of recovered data: http://www.access.recoverytoolbox.com/

Regards.

• Marked as answer by LebronJameson Saturday, May 24, 2014 11:36 AM

You can try to Compact and Repair your corrupt database. This is the very first solution you must try. If it doesn't work, this means the database is severely corrupted and can't be fixed by MS Access. In such situation you can use some third-party MS Access repair or recovery software. If you are looking for an effective and relevant solution, I will suggest you to use Recovery Toolbox for Access. It will resolve any type of corruption error from your database file and restore your maximum possible data to a new database file. Download its free demo version to see preview of recovered data: http://www.access.recoverytoolbox.com/

Regards.

• Marked as answer by LebronJameson Saturday, May 24, 2014 11:36 AM

You can try to Compact and Repair your corrupt database. This is the very first solution you must try. If it doesn't work, this means the database is severely corrupted and can't be fixed by MS Access. In such situation you can use some third-party MS Access repair or recovery software. If you are looking for an effective and relevant solution, I will suggest you to use Recovery Toolbox for Access. It will resolve any type of corruption error from your database file and restore your maximum possible data to a new database file. Download its free demo version to see preview of recovered data: http://www.access.recoverytoolbox.com/

Regards.

• Marked as answer by LebronJameson Saturday, May 24, 2014 11:36 AM

First, try to restore database from an updated backup. If you didn't have a backup, or backup is very old then you need to think again. 

in the meantime, when an Access database file is corrupt or damaged, then you can try several methods to repair and recover data from it:

1. First of all, try compact & repair.
2. Create a new blank database and import all the database objects into the new database. After moving the database, drop the problem database and rename the new database. It should get database back to normal.

If nothing work, then you may try third party Microsoft certified partner's products like Stellar Phoenix Access database repair. It supports MS Access 2013, 2010, 2007, 2003, 2002, & 2000.

• Edited by Markwillium Tuesday, June 03, 2014 11:14 AM spell

First, try to restore database from an updated backup. If you didn't have a backup, or backup is very old then you need to think again. 

in the meantime, when an Access database file is corrupt or damaged, then you can try several methods to repair and recover data from it:

1. First of all, try compact & repair.
2. Create a new blank database and import all the database objects into the new database. After moving the database, drop the problem database and rename the new database. It should get database back to normal.

If nothing work, then you may try third party Microsoft certified partner's products like Stellar Phoenix Access database repair. It supports MS Access 2013, 2010, 2007, 2003, 2002, & 2000.

• Edited by Markwillium Tuesday, June 03, 2014 11:14 AM spell

First, try to restore database from an updated backup. If you didn't have a backup, or backup is very old then you need to think again. 

in the meantime, when an Access database file is corrupt or damaged, then you can try several methods to repair and recover data from it:

1. First of all, try compact & repair.
2. Create a new blank database and import all the database objects into the new database. After moving the database, drop the problem database and rename the new database. It should get database back to normal.

If nothing work, then you may try third party Microsoft certified partner's products like Stellar Phoenix Access database repair. It supports MS Access 2013, 2010, 2007, 2003, 2002, & 2000.

• Edited by Markwillium Tuesday, June 03, 2014 11:14 AM spell

If all methods didn't work, it means the corruption can't be easily resolve by simple method. Normally these process work very well to repair minor corruption, but if you access database file is highly corrupted, then they not word. In such condition you can try some third-party access database recovery software. First download trial version from site then purchase full version. Try MS Access Database Recovery software to repair your corrupt database file.

Visit here : http://www.repairaccessdatabase.com/

It is a best solution to get back your corrupted MDB file and all objects. If you want to buy this software, then you can go on this site :- http://www.filesrecoverytool.com/access-file-recovery.html

If you want to solution for repairing corrupt MS Access database file, then you can try Compact and Repair features of Access to repair your corrupt database. It is the very first solution. If it doesn't work, then you should use third-party tool, Kernel for Access repair software. It gives you an effective and relevant solution. It will resolve any type of corruption error from your database file and restore your maximum possible data to a new database file.
Free download this tool here: http://www.accessrepair.recoveryfiles.org/

 This advance solution provide perfect recovery and restoring of access database with all queries, tables structure, primary keys, tables data and objects. It is fast solution to repair access database. This powerful tool takes few seconds to repair your severely damaged files. Go through: http://www.softmagnat.com/access-database-repair.html

This Access Database Repair software comes with all the major options and features with ribbon arrangement. So, there is no need to browse along the software for longer. All the options like Save, Select Database, Exit, Stop, Find Tree Item etc. are arranged in the ribbon. It also repairs corrupt MS Access (.MDB or .ACCDB) database file and then recover tables, queries, forms, macros, reports, etc. It also restores permanently deleted data from MDB file of MS Access 2013, 2010, 2007, 2003, 2002, 2000 Etc.

more details visit this site:- http://www.softmagnat.com/access-database-repair.html