Odd Report Behavior

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jorge Ramos - 05 Apr 2008 03:36 GMT

I have a database with multiple reports. All the reports run without a
problem except for one. This one report is behaving oddly. It will not open
when one attempts to run it. Also, if one attempts to open it in design view
to try to troubleshoot what is wrong, the report will not open either. Any
ideas as to what might be going on or how to fix it?

Reply to this Message

Allen Browne - 05 Apr 2008 04:17 GMT

Sounds like this one report has gone bad.

If you cannot even open it in design view, you could try the undocumented
SaveAsText/LoadFromText:
http://allenbrowne.com/ser-47.html#SaveAsText

Otherwise the best shot might be to delete this report, compact, and then
import it from a backup.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a database with multiple reports. All the reports run without a
>problem except for one. This one report is behaving oddly. It will not open
>when one attempts to run it. Also, if one attempts to open it in design
>view to try to troubleshoot what is wrong, the report will not open either.
>Any ideas as to what might be going on or how to fix it?

Reply to this Message

Jorge Ramos - 09 Apr 2008 03:11 GMT

Allen,

Seems like you’ve answered my last few posts to the Access newsgroup. Thank
you for, once again, coming up with an excellent solution. This time,
however, it seems like the report can not be recovered. I will have to
re-create the report but will save the undocumented solution for the next
time. Thanks!

Jorge

> Sounds like this one report has gone bad.
>
[quoted text clipped - 10 lines]
>>design view to try to troubleshoot what is wrong, the report will not open
>>either. Any ideas as to what might be going on or how to fix it?

Reply to this Message