Error: Cannot open anymore databases

G

Guest

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
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Cannot open anymore databases. 6
Can't create a report from my query in Access 1
Opening Report Closes Database 1
Obtain report page count with out previewing the report. 2
Access 2007-Report opens by default in Print Preview mode 2
query completions in code - threading issue? 1
Cannot open access reports 9
Error on printing report "Cannot open any more databases" 2

Top