By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

"Cant open any more databases" error

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.