<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<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>Jim:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've got 3 1/2 GB free. That enough?
Must be if the 2GB Access db limit is any indication. If the temp tables
holding the query results are inside the db then quite possibly is hitting the
Access limit without using up all the hd space? It's a select
query.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access Software</FONT></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=jimdettman@earthlink.net href="mailto:jimdettman@earthlink.net">Jim
Dettman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, September 04, 2003 7:51
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Query Results Too
Big?</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2><<</FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff size=2>I
have a query which is the record source for a report which eventually craps
out with the message 'Not enough space on temporary disk' or some such.
The query is joining 2 tables which each have over 2 million
records.</FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2>>></FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2> What type of query is it? If it's creating a snapshot of
the data, then you could easily run out of disk space. How much free
space do you have on your drive? I've done queries with 1,500,000
records without problems.</FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003></SPAN><SPAN
class=750474714-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2><<</FONT>
<DIV><FONT face=Arial color=#0000ff size=2>Is there a limit to how big a query
result Access can generate? Is there a setting to increase the
limit?</FONT></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2>>></FONT></SPAN></DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750474714-04092003><FONT face=Arial color=#0000ff
size=2> The only one I'm aware of is the 2048 table reference limit and
the fact that it must "compile" (Microsoft's term not mine) into a memory
space slightly larger then 64K (they have never said how much
larger).</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT></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>Rocky
Smolin - Beach Access Software<BR><B>Sent:</B> Thursday, September 04, 2003
10:39 AM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Query Results Too Big?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a query which is the record source for a
report which eventually craps out with the message 'Not enough space on
temporary disk' or some such. The query is joining 2 tables which each
have over 2 million records.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there a limit to how big a query result
Access can generate? Is there a setting to increase the
limit?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I think I may have reached the limit of Access
and am looking now for other ways to give the user what they want.
Short of going to MSDE.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE>
<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>