Cannot open any more databases

[CCIDBMNG]

I have a very large report with subreports based on quite a few linked tables. The report opens just fine but when I go to print the report I get the error "Cannot open any more databases" and one of the subreports doesn't print. Does anyone know why this is happening or how to fix it? It worked fine yesterday and now all of sudden I am getting this error.

 

[CCIDBMNG]

Thanks for trying but I have checked all the ldbs and they are all closed.

 

[Mae]

I ran into this same error message and my problem was that I had myself in a loop. It was on a form, but I had a control that was being calculated automatically in the Enter event and I inadvertanly had code somewhere that cause the Enter process to execute again. In the Enter code I was doing an OpenRecordset and so it kept performing an open each time it went thru.

So you might want to double check any code you are executing to make sure you are looping.

Hope this helps.

Mae

 

[CCIDBMNG]

I don't have any loops in my codes.

 

[Rich]

Do you have a lot of calculations in your underlying queries? Does the offending subReport print on its own?