[AccessD] Cannot Open Anymore Databases

One of the things that helps is to use JIT subforms as well.  JIT subforms only load subforms when 
the tab is clicked on.  Since every combo and subform uses a recordset, loading subforms JIT really 
cuts down the number of recordsets used.  It also speeds up loading the main form, sometimes 
drastically.

John W. Colby
www.ColbyConsulting.com

On 7/11/2011 2:20 PM, Darrell Burns wrote:
> 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