<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] 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=560524712-03102003><FONT face=Arial color=#0000ff
size=2>David,</FONT></SPAN></DIV>
<DIV><SPAN class=560524712-03102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560524712-03102003><FONT face=Arial color=#0000ff size=2>
The table reference limit is 2048 for JET 3.6 and up. See my earlier
post.</FONT></SPAN></DIV>
<DIV><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>
<BLOCKQUOTE>
<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> Thursday, October 02, 2003 6:18 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [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>Thanks for your
feedback</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> and advice</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> 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 face=Arial color=#0000ff
size=2>MVPS</FONT></U></SPAN><SPAN lang=en-au></SPAN></A><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> article
(although</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>referring</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2></FONT> <FONT face=Arial size=2>to
ACC97)</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>indirectly</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>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 face=Arial size=2></FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>Given what you
have mentioned,</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>I would be most</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>definitely</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> over the 128 limit
then. I have tried the</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>Just in time</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> method and have found it to be painfully
slow.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>The user clicks on a tab and has to wait for the records to be filtered
int</FONT><FONT face=Arial size=2>o</FONT><FONT face=Arial size=2></FONT>
<FONT face=Arial size=2>t</FONT><FONT face=Arial size=2>he subform</FONT><FONT
face=Arial size=2>.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> I put the recordsource</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>SQL</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>string in a Case statement linked to the tab
control.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> 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 face=Arial size=2>Cheers<BR></FONT><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></P>
<P align=left><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>Your
message</FONT><FONT face=Arial size=2> was</FONT><FONT face=Arial
size=2>:</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Date: Wed, 1
Oct 2003 19:30:02 -0400</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>From: "John
Colby" <jcolby@colbyconsulting.com></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Subject: RE:
[AccessD] Can't open any more databases</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>To: "Access
Developers discussion and problem solving"</FONT></SPAN></P>
<P align=left><SPAN lang=en-au>
<FONT face="Courier New"
size=2><accessd@databaseadvisors.com></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Message-ID:
<DCEFJAOENMNENLAAOF</FONT><FONT face="Courier New"
size=2>GPMEDBFDAA.jcolby@colbyconsulting.com></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Content-Type:
text/plain; charset="iso-8859-1"</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>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 face="Courier New" size=2>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 face="Courier New" 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</FONT><FONT face="Courier New"
size=2> 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 face="Courier New" color=#0000ff
size=2>www.colbyconsulting.com</FONT></U></SPAN><SPAN
lang=en-au></SPAN></A><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></P><BR></BLOCKQUOTE></BODY></HTML>