September 12, 2014 at 5:44 am
Hi, I have a corrupt database, and I'm trying to salvage my data. Any ideas? I have tried exporting the data to another database. I have also tried using JetComp as another way to compact/repair the database. Here is the error message I keep getting - even after attempting to compact and repair:
"Microsoft Office Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then on the tools menu, point to Database Utilities and Compact and Repair the Database. If you are currently trying to repair this corruption, then you will need to recreate this file or restore it from a previous Backup."
September 12, 2014 at 7:03 am
It would be helpful to know what version of Access you are working with, as well as the file format (.mdb or .accdb), but if the Compact and Repair function refuses to run, then your options are limited. One possibility is to create a new empty database, and then try to import data from the database that is corrupt. That will sometimes get some or most of your data, depending on table structures and the type of corruption. Otherwise, the only options are to revert to a backup (if you have one) or to employ one of the companies who offer data rescue as a service.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 12, 2014 at 10:31 am
Recovery Toolbox for Access can extract the following data from damaged files:
•the original structure of the previously used tables (indexes and fields)
•table data inside databases
•any queries except the ones used in reports and forms
•any correct relations except the ones used for displaying data (relations between columns of the same table)
For more information: http://goo.gl/lSvx3W
If this way didn't work, try to find the answer here: https://groups.google.com/forum/?hl=en#!topic/recovery-access2/2FNDbdO4lRU
September 12, 2014 at 1:58 pm
It appears that you have successfully recovered your database, or at least the tables and queries. From what I can tell, that tool doesn't recover forms, reports, macros or VBA and unfortunately that is where I see most corruptions take place. I also generally avoid 3rd party tools unless I can find explicit recommendations from developers in the Access community that have successfully used the tool. None of the several Access forums that I frequent or moderate make any mention of this tool, and I see only two user ratings on the home website for the tool. So double-check and make sure you got everything you need recovered.
A general note about the design of your database: To minimize the impact of corruption, we always split databases into a front-end containing queries, forms, reports, macros and VBA modules, and a back-end containing the tables. Then we backup the tables on a regular basis, and we take a backup of the front-end each time we deploy new changes. You might also find the advice on corruption at [font="Arial Black"]Steps to recover from Access database corruption[/font] quite useful. (That site also has a wealth of other information about Access development as well.)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply