Ms Access 2007 - Corrupted REPORTS - how to recover ?
Posted on 2012-08-14
I created an mdb with AC 2007 and have dozens of reports in it. It is a front-end / back-end design with another mdb as the backend data.
Suddenly MOST (if not all) reports quit working -- going after a few seconds to "(NOT RESPONDING)", after which only task manager can cancel MSACCESS.EXE.
Is there a way to recover all of these reports?
I have done Compact and repair on the original MDB to no avail. I have also created new mdbs and tried importing all objects from the original. When I do this, tables, queries, macros, and modules can all be opened in design view, but attempting to open ANY report in design view once again places access into "Not Responding"....
Compact and repair on the newly-cloned mdbs has no effect either.