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

 

[Steve]

Error message 1 is a red flag that the design structure of your tables is
not correct. I'll bet the recordsource of your report is a query and it is
very complicated.

Error 2 comes from dimming a variable as a database object and then using
the variabke somewhere in code before you use a Set statement setting the
value of the variable. For example:
Dim DB As DAO.Database
......
DB.OpenRecordset .......

There should be a statement before DB.OpenRecordset:
Set DB = CurrentDB.

Steve
(e-mail address removed)

 

[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.