[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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031003/e4e9268d/attachment-0001.html>