<!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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...something wrong there David ...I use JIT to
speed up a db, not slow it down :(((</FONT></DIV>
<DIV> </DIV>
<DIV>William Hindman<BR><<A
href="http://www.freestateproject.org">http://www.freestateproject.org</A>> -
Do you want liberty in your lifetime?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dfe@nudgeeinternational.com
href="mailto:dfe@nudgeeinternational.com">David Fenton</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, October 02, 2003 6:17
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Can't open any
more databases</DIV>
<DIV><BR></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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>