[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030904/e53d6246/attachment-0001.html>