I created a report in MS access 2003 and linked it to a query. The report does not open. It seems like it is trying to open and the computer is loud but it does not open. When I look at the task list, the program is not responding. I compacted the database and put in the query criteria to select only one record and still did not open. The query itself opens right away but not the report that is linked to it.
IF the query opens immediately, so should the report.
You said you tried re-creating the report. What happened? Did a brand new report fail to open as soon as it was connected to the query? When exactly did the newly created report start to exhibit the same behaviour?