<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Just in Time (off shoot of 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>David</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...rather than write a tome on what you are and are
not doing, please go to <A
href="http://www.colbyconsulting.com">www.colbyconsulting.com</A> and
dl JC's JIT sample db ...its documented pretty well ...each of us has their
own flavor of this but JC's will get you on a much faster path ...HTH
:)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </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:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Just in Time (off
shoot of 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>Charlotte</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> and William</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>, you have</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>both</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>got me thinking!</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>Yes I do use the
Master/Child filter, but when the form is first loaded</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>all of its
subforms</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>sit</FONT><FONT face=Arial size=2> there blank behind
the</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>ir appropriate</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> tab</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>s</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>each with</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>no
recordsource)</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>
</SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>W</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>hen the user clicks
on</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>each</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> tab I assign an SQL string to the
recordsource</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> of the subforms under that tabb</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2>, the form opens
the record source and</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>each child</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> subform does 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 master/child filtering. All is well, but it IS
slow</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>Is this the accep</FONT><FONT face=Arial size=2>ted way to
do</FONT></SPAN><SPAN lang=en-au></SPAN><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> Because</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> if you are saying it should be faster,
then I</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>d like to</FONT><FONT face=Arial size=2> do it properly so
that it IS faster on my application.</FONT> <FONT face=Arial size=2>I must be
doin</FONT><FONT face=Arial size=2>g somethi</FONT><FONT face=Arial size=2>ng
wrong.</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>A sample of my
code:</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> </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></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> Case 6</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></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face=Arial size=2>Transfers IN</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN
lang=en-au> </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>Simple</FONT><FONT face=Arial size=2> procedure
to</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>r</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2>emove recordsources from forms hidden</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>when</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial size=2> user leav</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>es</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial size=2> previous
tab</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> </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> </SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>ClearRecordSource
(Forms!frmEN_AddEnrolmentFees!sfrmTransferOUT.Form)</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> </SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>ClearRecordSource
(Forms!frmEN_AddEnrolmentFees!sfrmTransferDetailsOUT.Form)</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> </SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial size=2>ClearRecordSource
(</FONT><FONT face=Arial
size=2>Forms!frmEN_AddEnrolmentFees!sfrmTransferDetailsIN.Form)</FONT></SPAN></P>
<P align=left><SPAN
lang=en-au> </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</FONT><FONT face=Arial size=2>et</FONT> <FONT face=Arial
size=2>up the recordsource strings</FONT><FONT face=Arial size=2> for the
three</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>visible</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>subforms (master and two child</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial
size=2>ren</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></SPAN></P>
<P align=left><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>
<FONT face=Arial size=2>Dim rsIN As String</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>Master subform</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2> recordsource</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> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>Dim rsINfromDetails As String</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>child 1 subform</FONT><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>recordsource</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> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>Dim rsINtoDetails As String</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>child 2 subform</FONT><FONT face=Arial
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face=Arial size=2>recordsource</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></P>
<P align=left><SPAN
lang=en-au> </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>Assign the strings to the variables</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<UL>
<UL>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>rsIN = "SELECT
tbl_Transfer.Trf_ID AS TransferID, tbl_Transfer.Trf_Num AS
TrfNumber,</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>tbl_Transfer.Trf_Printed AS</FONT> <FONT face=Arial
size=2>Printed,</FONT> <FONT face=Arial size=2>tbl_Transfer.Trf_Date AS
DateIssued, tbl_</FONT><FONT face=Arial
size=2>Transfer.Trf_Description,</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>tbl_Transfer.Trf_Enrol_ID_out AS fromEnrolID,
tbl_Transfer.Trf_Enrol_ID_in AS toEnrolID,</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>tbl_Transfer.Trf_Amount AS AmtTransferred FROM
tbl_Transfer;"</FONT></SPAN></P></UL></UL>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>rsINfromDetails =
"qryEN_FI_TransferDetailsOUT"</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>rsINtoDetails = "qryEN_</FONT><FONT face=Arial
size=2>FI_TransferDetailsIN"</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN></P>
<P align=left><SPAN
lang=en-au> </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>Assign recordsources to the three subforms under tab user
just clicked on</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> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>mainTrfINfrm.RecordSource = rsIN</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></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial size=2>Where mainTrfINform is a form
object</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT face=Arial
size=2>previously</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>set</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> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>detailTrfINfrom.RecordSource =
rsINfromDetails</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial
size=2> </FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> </SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au>
<FONT face=Arial size=2>detailTrfINto.RecordSource =
rsINtoDetails</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>etc</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></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face=Arial size=2>Any ideas</FONT><FONT
face=Arial size=2>?</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<BR></FONT><FONT face=Arial
size=2>David ΤΏΤ¬<BR>Ext 0751</FONT></SPAN></A><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-au> </SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Times New Roman">Your
message</FONT></SPAN><SPAN lang=en-au><FONT
face="Times New Roman">s</FONT></SPAN><SPAN lang=en-au><FONT
face="Times New Roman">:</FONT></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Date: Thu, 2
Oct 2003 15:31:12 -0700</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>From:
"Charlotte Foust" <cfoust@infostatsystems.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:</FONT></SPAN></P>
<P align=left><SPAN lang=en-au>
<FONT face="Courier New" size=2><E61FC1D4B191</FONT><FONT
face="Courier New"
size=2>8244905B113C680BEA86312342@infoserver01.infostat.local></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>Why are they
waiting for records to be filtered? Aren't you also setting the master
and child links for the subforms? That is generally a much faster</FONT>
<FONT face="Courier New" size=2>way to filter a subform than changing the
recordsource.</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Charlotte
Foust</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT><FONT face="Courier New"
size=2>
</FONT><FONT face="Courier New" size=2>
</FONT><FONT
face="Courier New" size=2>
</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Date: Thu, 2
Oct 2003 18:33:26 -0400</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>From: "William
Hindman" <wdhindman@bellsouth.net></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:
<002601c38935$321</FONT><FONT face="Courier New"
size=2>980b0$6001a8c0@dejpolsys></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>RE: [AccessD]
Can't open any more databases...something wrong there David ...I use JIT to
speed up a db, not slow it down :(((</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>William
Hindman</FONT></SPAN><SPAN lang=en-au></SPAN></P>
<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>