<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=355175315-04092003></SPAN> </DIV>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff size=2>I'm
just guessing here, but isn't there a 2GB limit on files in most OSes have a 2GB
limit? If so, and Access is creating a temporary file, you may be hitting
that limit.</FONT></SPAN></DIV>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff size=2>Maybe
if you check your temp directory when you get that message, you'll be able to
see a temporary file.</FONT></SPAN></DIV>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=355175315-04092003><FONT face=Arial color=#0000ff
size=2>Bobby</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us 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 11:23
AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] Query Results Too
Big?<BR><BR></FONT></DIV>
<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><FONT face=Arial color=#0000ff size=2></FONT> </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></BLOCKQUOTE></BODY></HTML>