<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Bericht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=878300616-04092003><FONT face=Arial color=#0000ff size=2>2GB
limit on FAT16, not sure for FAT32 (I believe so). NTFS is no
prob.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=nl 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>Bobby
Heid<BR><B>Sent:</B> Thursday, September 04, 2003 5:59 PM<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><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></BLOCKQUOTE></BODY></HTML>