<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Can't open any more databases</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=653272723-01102003><FONT face=Arial color=#0000ff size=2>In
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.</FONT></SPAN></DIV>
<DIV><SPAN class=653272723-01102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=653272723-01102003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>David
Fenton<BR><B>Sent:</B> Wednesday, October 01, 2003 6:30 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Can't open any more
databases<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>I have a ACC2002 db
that opens many forms and queries etc.</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>I
don</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>t believe I am anywhere near the 2048 max table
references.</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>It</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>s a split database. I have a form</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>
(F</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>orm</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> A)</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> open which contains a tab control with a
form and subform on at least each of the</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>ten</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> tabs.</FONT> <FONT face=Arial
size=2>Click</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>ing</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> on a button on one of
the</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>se</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> tabs, hides this main form</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> (Form</FONT><FONT
face=Arial size=2> A</FONT><FONT face=Arial size=2> -</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>with all of
it</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>s open forms etc) and opens another form</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>(Form
B)</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>with a tab control and a bunch of forms. Each tab (</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>seven
tabs)</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>. I can happily click on a couple of the tabs and everything is fine.
As soon as I click on one of the last tabs which</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>contain</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2></FONT> <FONT face=Arial size=2>3</FONT><FONT face=Arial
size=2> subforms</FONT><FONT face=Arial size=2> I get the
dreaded</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>Can</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>t open any more databases</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> message.</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>I have
read</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>a lot of</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>posts</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> on this</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>(incl.</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 face=Arial color=#0000ff
size=2>www.mvps.org/access/bugs/bugs0010.htm</FONT></U></SPAN><SPAN
lang=en-au></SPAN></A><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>)</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>and have thoroughly
checked</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>my code to ensure</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>that</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>
all</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>m</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>y</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>recordset</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> objects are closed</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> after
use</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>I</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>temporarily</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>rectified it by clo</FONT><FONT face=Arial
size=2>s</FONT><FONT face=Arial size=2>ing the calling form</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> (Form
A)</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2> instead of hiding it</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>, thus closing some of the table
references</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>. Form B works perfectly now. I only get the error if too
many forms are open which have obviously opened too many table
references.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>The drawback is that it is slow to open Form B because it is
closing Form A and when I close Form B, I have to wait for it to
re</FONT><FONT face=Arial size=2>-open Form A again and filter to the record
the user was working on before they clicked the button to take then to Form
B.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>My question: Is there
anything else that I could do that I may not have
considered</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>?</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>I believe that at most I have
abo</FONT><FONT face=Arial size=2>u</FONT><FONT face=Arial
size=2>t</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>6</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>0-</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>8</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>0 table references open</FONT><FONT face=Arial size=2> at
any instant (knowing that it</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2></FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>s a split database
let</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>s double that to 1</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>6</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>0 references)</FONT><FONT face=Arial size=2>. Even if I am
conservative and say I have caused 500 table references and double that to
1000, it is still nowhere near the limit of 2048.</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>I believe it is a
hardcoded limit of Jet 3.6</FONT><FONT face=Arial size=2>.</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> Am I barking up
the wrong tree completely?</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><SPAN
lang=en-au><FONT face=Arial size=2>Cheers</FONT></SPAN></A><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>in advance for any assistance or
advi</FONT><FONT face=Arial size=2>ce.</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-au><BR></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>David ΤΏΤ¬<BR></FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>Brisbane</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2>Australia</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-au> </SPAN></P>
<P align=left><SPAN lang=en-au></SPAN></P></BLOCKQUOTE></BODY></HTML>