I have a report (RptPaymentRecord) which if I open it in preview and then
print it - no problems If I open the report in preview from a form
(PaymentRecord) which basically shows the same data as in the report then
print it, again no problems
If I open that form from a Menu form, then open the PaymentRecord Form then
open the RptpaymentRecord in preview, again no problems. If I then go to
print the report, the printer queue shows it is spooling, then that message
vanishes and nothing prints.

Obviously the problem appears to be "Too many databases open" though I don't
get an error message. I don't really want to close the PaymentRecord form
prior to printing, as it takes quite a few seconds to open again . Somehow I
would like to close the preview version of the report and open it again
normally (ie in print mode).

Any bright ideas please?

Phil

Phil wrote:
You aren't a newbie and know what you're doing so maybe some
experimentation is required. Why not create a new database, copy your
mainmenu, form, and report over along with your tables/links and
requisite queries for the process and try it from the new database?
Same thing?

On 15/04/2010 18:43:12, Salad wrote:
Spot on, Salad. I was convinced it was a "Too many databases open error". I
have found in the past that that particular error is not always reported
correctly, but as you surmised, it was a corrupt Db

Thanks again

Phil

Phil wrote:

Glad you are onto other issues!