Reports in Access not responding

[Guest]

I can no longer preview, design or create reports in databases that I have
created. Even if I build a database from scratch, Access does not respond
in the Reports Database Window, not even an error message. Does anybody know
what this could be? I'm stuck in the mud!!

 

[Guest]

Never mind.....found the answer at this post

New member here. I'm attempting to create a report from a query. The query is
built on two crosstabs and 3 small select queries, all joined by
"InspectorName". The query itself produces the exact desired result, and runs
beautifully. However, when I try to create a Report, Access 2003 (sp1) stops
responding. Task Manager end process is my only choice.

Default printer is set. Driver is current. Parameters in both crosstab
queries are correct. Column headings properties are correct. Everything
appears "set", as indicated by the verified correctedness of the query.

I also kept open a table linked to the backend...as someone suggested to
speed things up.

The main table is a backend link. No problems running less complex queries
and creating reports based on the same table. Any advice is appreciated. I'd
rather avoid a maketable approach.