Print errors

[Mary M]

I get the following errors when attempting to print a report - but the errors
are not valid. Has anyone else had this experience and what did you do to
correct? This is a very large database.
1) Cannot open any more tables & 2) Object invalid or no longer set. --
Mary M

 

[Mary M]

1) You are correct, the recordsouce of the report is a very complicated
query. I've checked the tables and do not find a problem with the design
structure. Would you recommend I use temporary tables instead of a query?
2) Checked this as well. The value of the variable is set. I changed it to
the actual report name instead of using a dim stmt. Now it just gives me a
"not enough memory" error but I have loads of memory.