[AccessD] Can't open any more databases

Why are they waiting for records to be filtered?  Aren't you also setting the master and child links for the subforms?  That is generally a much faster way to filter a subform than changing the recordsource.

Charlotte Foust

-----Original Message-----
From: David Fenton [mailto:dfe at nudgeeinternational.com] 
Sent: Thursday, October 02, 2003 2:18 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Can't open any more databases


Thanks for your feedback and advice John. The MVPS <http://www.mvps.org/access/bugs/bugs0010.htm>  article (although referring to ACC97) indirectly led me to believe that Jet 3.6 allowed 2048 references since the old Jet allowed 1024. Given what you have mentioned, I would be most definitely over the 128 limit then. I have tried the 'Just in time' method and have found it to be painfully slow. The user clicks on a tab and has to wait for the records to be filtered into the subform. I put the recordsource SQL string in a Case statement linked to the tab control. Perhaps I need to review the filtering or something.

Cheers
David Ô¿Ô¬
Brisbane

Australia 

Your message was:

Date: Wed, 1 Oct 2003 19:30:02 -0400

From: "John Colby" <jcolby at colbyconsulting.com>

Subject: RE: [AccessD] Can't open any more databases

To: "Access Developers discussion and problem solving"

        <accessd at databaseadvisors.com>

Message-ID: <DCEFJAOENMNENLAAOFGPMEDBFDAA.jcolby at colbyconsulting.com>

Content-Type: text/plain; charset="iso-8859-1"

Can't open any more databasesIn fact the number is no where near that, at least for a2K.  Something like 128.  This includes ALL queries (combos, lists, recordsets, forms, subforms, reports etc) open at one time.  I ran into this in a very complex form when they had several other forms open.

One thing I'd suggest if it works for you is "Just in time" subforms on the tabs.  The idea is to load the subforms on tabs as they are clicked on and unload them as the next tab is clicked on. John W. Colby www.colbyconsulting.com <file://www.colbyconsulting.com>