<!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 (Concluded)</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Thank you for your excellent insights Jim,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Looks like it</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">s back to the drawing board. I</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">m definitely pushing the limit</FONT><FONT SIZE=2 FACE="Arial">s of the table references then.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> What do you make of 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 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"> where they refer to 1024 references?</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"> When I noticed that</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> Susan was</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></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">to a specific problem that occurs on Novell</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">, I knew that</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> since I</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">m on Win2000 server</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">it wouldn</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">t</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">help</FONT><FONT SIZE=2 FACE="Arial">.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">I have temporarily solved</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">the problem</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> by closing other forms that happened to be open at the same time, thereby closing some references.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">I will experiment with</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">refining</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"></FONT> <FONT SIZE=2 FACE="Arial">the record source under the open</FONT> <FONT SIZE=2 FACE="Arial">sub</FONT><FONT SIZE=2 FACE="Arial">forms on the offending form.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> But since I can never</FONT> <FONT SIZE=2 FACE="Arial">predict</FONT><FONT SIZE=2 FACE="Arial"> what forms the user might have open, I</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">d prefer</FONT> <FONT SIZE=2 FACE="Arial">to work towards</FONT> <FONT SIZE=2 FACE="Arial">a more robust solution</FONT> <FONT SIZE=2 FACE="Arial">so</FONT><FONT SIZE=2 FACE="Arial"> that I can be 100% certain the user will never see the error message.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Anyway, thanks for you</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">r</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">valued</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">help</FONT><FONT SIZE=2 FACE="Arial">.</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 SIZE=2 FACE="Arial">Cheers<BR>
David</FONT></SPAN></A><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT SIZE=2 FACE="Arial">Fenton</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">ԿԬ<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><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"> </SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Your message was:</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"><FONT SIZE=2 FACE="Courier New">Date: Thu, 2 Oct 2003 06:45:54 -0400</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">From: "Jim Dettman" <jimdettman@earthlink.net></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: <NEBBKADGELICHEJJCKGKEECMHIAA.jimdettman@earthlink.net></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 databases</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">David,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New"><<I believe that</FONT><FONT SIZE=2 FACE="Courier New"> at most I have about 60-80 table references open at any</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">instant (knowing that it</FONT><FONT SIZE=2 FACE="Courier New">’</FONT><FONT SIZE=2 FACE="Courier New">s a split database let</FONT><FONT SIZE=2 FACE="Courier New">’</FONT><FONT SIZE=2 FACE="Courier New">s double that to 160</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">references). Even if I am conservative and say I have caused 500 table</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">references and double that to 1000, it is still nowhere nea</FONT><FONT SIZE=2 FACE="Courier New">r the limit of</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">2048. I believe it is a hard</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">-</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">coded limit of Jet 3.6. Am I barking up the</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">wrong tree completely?>></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New"> Yes but "table references" is probably not what you think it is. Not only</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">does it mean every open table, but it also applies to every field</FONT> <FONT SIZE=2 FACE="Courier New">reference</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">(which is in of itself a table reference). It can add up a lot quicker then</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">you think, especially with multiple subforms.</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New"><<It</FONT><FONT SIZE=2 FACE="Courier New">’</FONT><FONT SIZE=2 FACE="Courier New">s a split database. I have a form (Form A) open which contains a tab</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">control with a form and subform on at least each</FONT><FONT SIZE=2 FACE="Courier New"> of the ten tabs. Clicking</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">on a button on one of these tabs, hides this main form (Form A - with all of</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">it</FONT><FONT SIZE=2 FACE="Courier New">’</FONT><FONT SIZE=2 FACE="Courier New">s open forms etc) and opens another form (Form B) with a tab control and</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">a bunch of forms. Each tab (seven tabs).>></FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New"> </FONT></SPAN><SPAN LANG="en-au"><I></I></SPAN><SPAN LANG="en-au"><I> <FONT SIZE=2 FACE="Courier New">From what you describe, it certainly sounds like you are bumping into the</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">limit. And yes, the bad news is that the limit is internal to Access and</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">cannot be modified. Your only choice is to reduce the complexity of what's</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">going on.</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New"> </FONT></SPAN><SPAN LANG="en-au"><I></I></SPAN><SPAN LANG="en-au"><I> <FONT SIZE=2 FACE="Courier New">The other then tha</FONT><FONT SIZE=2 FACE="Courier New">t Susan mentioned is in regards to locks. It is</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">possible that you are running out of locks and therefore cannot open another</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">database because you can't place a user lock. This applies only to Novell</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">environments. To test this out, place both the FE and</FONT> <FONT SIZE=2 FACE="Courier New">BE on the same</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">station and try the operation again. If the error still occurs, then it's</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><I><FONT SIZE=2 FACE="Courier New">not related to locking.</FONT></I></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Jim Dettman</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">President,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">Online Computer Services of WNY, Inc.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">(315) 699-3443</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Courier New">jimdettman@earthlink.net</FONT></SPAN></P>
</BODY>
</HTML>