Cannot open any more tables

[Brett Barry: Go Get Geek!]

I've searched on this error and I'm not very clear on the solutions.
Yes, I've created a very complex report with 16 subreports. And I get
this error only when I try to print the report (even if I don't do a
print preview first).

Am I supposed to consolidate my queries (about 18 of them) into one
super huge query? And then create the 8 or 16 different subreports
based on just that one query?

Or should I just try to scale down my 18 queries into 9 queries. I've
spent so much time already I don't want to make modifications only to
find out it still won't work.

Thanks,
Brett

 

[bhicks11 via AccessMonster.com]

Hi Brett,

I think your queries and reports/subreports are pretty complicated and it's
not possible to answer this question without actually knowing the details.
It might be a case trying out different scenarios to see how it responds.

Anybody else know something different?

Bonnie
http://www.dataplus-svc.com