Cannot edit Report!

[davesmith202]

I am getting a rather strange error in one of my reports in Access 2007. If I edit the report, click the cross to close, click Yes to save, nothing happens - it is still open. If I close and reopen, the changes are missing.

Now if I copy and paste this Report, I get this error: Name conflicts with existing module, project, or object library.

What gives?

Thanks,

Dave

 

[boblarson]

Possible corruption. You might try importing everything into a blank database shell and see if that helps.

 

[davesmith202]

Already tried it. I get the same error when trying to import. I get the first error and then No current record.

 

[boblarson]

If you get the same error when trying to import (I assume, during the actual import process) then your report is likely corrupt.

 

[davesmith202]

Yup, you were right Bob. Corrupted. I uncorrupted it! Thanks for your diagnosis!

 

[boblarson]

Yup, you were right Bob. Corrupted. I uncorrupted it! Thanks for your diagnosis!

So how did you recover it?

 

[davesmith202]

I work for a company linked to corruption removal! Or more accurately, I work for Access World. They used their proprietary system, which all I know is more powerful than using Compact and Repair (which incidentally didn't remove the corruption).

 

[boblarson]

I didn't expect Compact and Repair to work. But no worries as I would not expect you to reveal trade secrets.

 

[davesmith202]

Well understood Bob! My hands are tied!

 

[Joe8915]

So how did you recover it?

Bob, just had the same problem. Sure would be great to see how he fix the problem