"Cant open any more databases" error

[Niranjan]

I have a relatively straight forward report. The query that populates
data for this report is complicated. The report opens without any
problem and I can print it as well.

However, If I have another form open (has about 12 combo boxes) and
then I run the report, it appears on the screen, no problem. When I
print the report, I get 'Cant open any more databases' error.

I am using OpenQuery method to run some queries before opening the
report. I am just wondering if I should use qdf.execute method, will
that help any?

Obviously, having that additional form open is creating the problem.
Does anyone know what is the maximum limit of the open recordsets?

-Niranjan

[Salad]

Niranjan wrote:

I have a relatively straight forward report. The query that populates
data for this report is complicated. The report opens without any
problem and I can print it as well.

However, If I have another form open (has about 12 combo boxes) and
then I run the report, it appears on the screen, no problem. When I
print the report, I get 'Cant open any more databases' error.

I am using OpenQuery method to run some queries before opening the
report. I am just wondering if I should use qdf.execute method, will
that help any? d
I doubt it. OpenQuery if for a simple Select query. Execute, as
mentioned in help, is for action queries....updates, deletes, appends,
and the like.
Obviously, having that additional form open is creating the problem.
It really isn't that obvious.

Are you doing anything like
Dim dbs As Database
Set dbs = ....
and not doing
dbs.close
set dbs = Nothing
Does anyone know what is the maximum limit of the open recordsets?

-Niranjan