"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]

Re: "Cant open any more databases" error

Niranjan wrote:
[color=blue]
> 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[/color]

I doubt it. OpenQuery if for a simple Select query. Execute, as
mentioned in help, is for action queries....upda tes, deletes, appends,
and the like.[color=blue]
>
> Obviously, having that additional form open is creating the problem.[/color]

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
[color=blue]
> Does anyone know what is the maximum limit of the open recordsets?
>
> -Niranjan[/color]