[AccessD] Cannot Open Anymore Databases

And couple JIT with a tab control and you eliminate a lot of your issues
immediately.

Charlotte Foust

On Thu, Jul 14, 2011 at 7:58 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> 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@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>
>> [mailto:accessd-bounces@**databaseadvisors.com<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<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>