[AccessD] Query Results Too Big?

Bobby Heid bheid at appdevgrp.com
Thu Sep 4 10:59:03 CDT 2003


Rocky,
 
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.
 
Maybe if you check your temp directory when you get that message, you'll be
able to see a temporary file.
 
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, September 04, 2003 11:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Results Too Big?


Jim:
 
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.
 
Regards,
 
Rocky Smolin
Beach Access Software
 

----- Original Message ----- 
From: Jim  <mailto:jimdettman at earthlink.net> Dettman 
To: Access Developers discussion and  <mailto:accessd at databaseadvisors.com>
problem solving 
Sent: Thursday, September 04, 2003 7:51 AM
Subject: RE: [AccessD] Query Results Too Big?


Rocky,
 
<<
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.
>>
 
 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.
 
<< 
Is there a limit to how big a query result Access can generate?  Is there a
setting to increase the limit?
>>
 
  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).
 
Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, September 04, 2003 10:39 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Query Results Too Big?


Dear List:
 
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.
 
Is there a limit to how big a query result Access can generate?  Is there a
setting to increase the limit?
 
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.
 
TIA
 
Rocky Smolin
Beach Access Software
 



  _____  




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030904/c3cbb3c7/attachment-0001.html>


More information about the AccessD mailing list