<!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=100473710-02102003><FONT face=Arial color=#0000ff
size=2>David,</FONT></SPAN></DIV>
<DIV><SPAN class=100473710-02102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=100473710-02102003><FONT face=Arial size=2><<I believe
that at most I have abo<FONT face=Arial size=2>u</FONT><FONT face=Arial
size=2>t</FONT><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face="Times New Roman" size=3> </FONT><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="Times New Roman" size=3> </FONT><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></FONT></SPAN></DIV>
<DIV><SPAN class=100473710-02102003><FONT face=Arial color=#0000ff size=2><FONT
color=#000000><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=100473710-02102003>
<DIV><SPAN class=700503310-02102003><FONT face=Arial color=#0000ff
size=2> <SPAN class=100473710-02102003>Yes but "table references" is
probably not what you think it is. Not only does it mean every open table,
but it also applies to every field reference (which is in of itself a table
reference). It can add up a lot quicker then you think, especially
with multiple subforms.</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=700503310-02102003><FONT face=Arial color=#0000ff size=2><SPAN
class=100473710-02102003></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=700503310-02102003><FONT face=Arial size=2><SPAN
class=100473710-02102003><<<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="Times New Roman" size=3>
</FONT><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="Times New Roman"
size=3> </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="Times New Roman" size=3> </FONT><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="Times New Roman" size=3>
</FONT><FONT face=Arial size=2>(Form B)</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face="Times New Roman" size=3>
</FONT><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>.>></FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=700503310-02102003><FONT face=Arial size=2><SPAN
class=100473710-02102003></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=700503310-02102003><FONT><SPAN
class=100473710-02102003></SPAN></FONT></SPAN><SPAN
class=700503310-02102003><FONT><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=100473710-02102003> From what you describe, it
certainly sounds like you are bumping into the limit. And yes, the bad
news is that the limit is internal to Access and cannot be modified</SPAN>.<SPAN
class=100473710-02102003> Your only choice is to reduce the complexity of
what's going on.</SPAN></FONT></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=700503310-02102003><FONT><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=100473710-02102003></SPAN></FONT></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=700503310-02102003><FONT><FONT><FONT><SPAN
class=100473710-02102003></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=100473710-02102003> The other then that Susan mentioned
is in regards to locks. It is possible that you are running out of locks
and therefore cannot open another database because you can't place a user
lock. This applies only to Novell environments. To test this out,
place both the FE and BE on the same station and try the operation again.
If the error still occurs, then it's not related to
locking.</SPAN></FONT></FONT></FONT></FONT></FONT></FONT></SPAN></DIV>
<DIV></SPAN><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></DIV></DIV>
<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>