[AccessD] Cannot Open Anymore Databases

I had the same problem with a form that had 5 subforms, each with multiple
queries. I submitted the question to every forum and discovered that there's
no easy cure. The connections limit is 256 but there's no function to tell
you how many you've used up. Connections to a back-end database count
double. After spending lots of time re-engineering my recordset actions and
being very meticulous about closing connections, the final solution was to
bind the subforms to temp tables and fill the tables as each tab is clicked.
So, your solution is the correct one.
- Darrell

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Thursday, July 07, 2011 6:00 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Cannot Open Anymore Databases

Hey All
Just curious. I was working on a report, I would view it and when I returned
to the design mode I would get the error message "Cannot open anymore
databases". The report is based on a union query, which is made up of 6
subqueries. each of these subqueries is based on the results from about 3 or
4 other querys. If I manually run the union query I don't get any error
messages, as I mentioned I only get the error message when working with the
report. Am I correct in assuming that the results of each of these queries
results in 1 instant of the database being opened and I have exceeded the 84
(whatever) limit to the number of databases instances that can be open at
one time??  I solved the problem by appending the results of each of the 6
queries to a temp table and using the table for the report. 
 
T. Septav
Nanaimo, BC
Canada
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com