Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"Cannot Open Any More Databases" on Report Print
I found the answer. This is really "too many tables open." When a report is opened, it runs the queries to generate the preview window. When you hit "print", it runs all the queries AGAIN, pushing the number of temporary tables over the top. The answer is to do a custom form with a print button...- miken51
- Post #3
- Forum: Microsoft: Access Reports
-
"Cannot Open Any More Databases" on Report Print
I have a report which contains 3 subreports (with one other subreport in one of each of the subreports). The report displays on the screen, but when I try to print it, I get "Cannot Open Any More Databases". If I click on ok to clear it, it will come back a few times, then print only the parts...- miken51
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
