<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6396.0">
<TITLE>RE: [AccessD] Can't open any more databases</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Thanks for your feedback</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> and advice</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> John. The</FONT></SPAN><SPAN LANG="en-au"> </SPAN><A HREF="http://www.mvps.org/access/bugs/bugs0010.htm"><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><U></U><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">MVPS</FONT></U></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> article (although</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">referring</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"></FONT> <FONT SIZE=2 FACE="Arial">to ACC97)</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">indirectly</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">led me to believe that Jet 3.6 allowed 2048 references since the old Jet allowed 1024.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">Given what you have mentioned,</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">I would be most</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">definitely</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> over the 128 limit then. I have tried the</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">‘</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Just in time</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> method and have found it to be painfully slow.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">The user clicks on a tab and has to wait for the records to be filtered int</FONT><FONT SIZE=2 FACE="Arial">o</FONT><FONT SIZE=2 FACE="Arial"></FONT> <FONT SIZE=2 FACE="Arial">t</FONT><FONT SIZE=2 FACE="Arial">he subform</FONT><FONT SIZE=2 FACE="Arial">.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> I put the recordsource</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">SQL</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">string in a Case statement linked to the tab control.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> Perhaps I need to review the filtering or something.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"></SPAN><A NAME=""><SPAN LANG="en-au"></SPAN></A></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Cheers<BR>
</FONT><FONT SIZE=2 FACE="Arial">David ԿԬ<BR>
</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Brisbane</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Australia</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Your message</FONT><FONT SIZE=2 FACE="Arial"> was</FONT><FONT SIZE=2 FACE="Arial">:</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Date: Wed, 1 Oct 2003 19:30:02 -0400</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">From: "John Colby" <jcolby@colbyconsulting.com></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Subject: RE: [AccessD] Can't open any more databases</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">To: "Access Developers discussion and problem solving"</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Courier New"><accessd@databaseadvisors.com></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Message-ID: <DCEFJAOENMNENLAAOF</FONT><FONT SIZE=2 FACE="Courier New">GPMEDBFDAA.jcolby@colbyconsulting.com></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Content-Type: text/plain; charset="iso-8859-1"</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">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, form</FONT><FONT SIZE=2 FACE="Courier New">s, subforms, reports etc) open at one time. I ran into this in a very complex form when they had several other forms open.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">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</FONT><FONT SIZE=2 FACE="Courier New"> are clicked on and unload them as the next tab is clicked on. John W. Colby</FONT></SPAN><SPAN LANG="en-au"> </SPAN><A HREF="file://www.colbyconsulting.com"><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><U></U><U><FONT COLOR="#0000FF" SIZE=2 FACE="Courier New">www.colbyconsulting.com</FONT></U></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<BR>
</BODY>
</HTML>