"cannot open any more databases" (1 Viewer)

[jonnie_c]

i have a report which has several subreports. Each one of these subreports uses many queries. I have never had any problems printing this report before, however, now when I go to print it i recieve the message "cannot open any more databases" and it prints only part of the report. I am having no problems previewing the report. Any ideas on why this might be occuring?

 

[Alexandre]

Check whether you have opened db or recordset objects that you didn't close properly in your code (ex: Dim db as Database, set db = CurrentDb() ....your code.... Set db = Nothing 'Free up the pointer to your db object)

 

[jonnie_c]

no recordsets being used in this report. as a matter of fact, no cade at all. any other ideas?

 

[jonnie_c]

err.. code, not cade

 

[Alexandre]

I believe you should try to find how to simplify your report (less subreports, less queries). hard to do better suggestions without having an idea about what you've got in your hands. Can you upload something?