Error on printing report "Cannot open any more databases"

[Graham]

I have a complex report which when previewed appears
normal, or when printed directly prints normally. However
if I preview and then press print I receive the
error "Cannot open any more databases." and have to press
the "OK" button, this happens two or three times then the
report prints, but with two or three of the subreports
missing.

Any ideas as to what I can do.

 

[Terry Reardon]

mumm..
I've never ran across this problem before. But, I would
investigate erroneous errors initiating from those
subforms first, then see if the problem goes away. Not
that, then who knows... you have all the service packs
right...lots of memory... compacted the db lately?

Divide and Conquer!
T.

 

[Guest]

Terry or anyone did you get any further on this I am experiencing the same problem with complex MI reports which include sub reports. I have not seen this before even when completing a main report with over 35 sub reports built in from an ODBC back end. Do we think it could be a memory problem

thank

pete

----- Terry Reardon wrote: ----

mumm.
I've never ran across this problem before. But, I would
investigate erroneous errors initiating from those
subforms first, then see if the problem goes away. Not
that, then who knows... you have all the service packs
right...lots of memory... compacted the db lately

Divide and Conquer
T