Error: Cannot open anymore databases

[RTimberlake]

I have a report that compiles data from multiple databases. I can preview the
report and everything looks fine. However, when I try to print the report I
get the following error (several times): Cannot open anymore databases.
Is there a limit to the number of databases that you can access at one time?
Does anyone know how I can solve this problem. Currently, my users are having
to submit the report in the form of an e-mail attachment, then they can print
the report from there. I really need to take out this step.

Thank you for your time and your thoughts.
Rebecca

 

[Duane Hookom]

You haven't told us much about your report other than it compiles from
multiple databases. Are you using combo or listboxes on your report? Are you
using domain aggregate functions like DSum() or DLookup()? Are you using any
code in your report that creates recordsets?