<!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><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></BODY></HTML>