[AccessD] Query Results Too Big?

Are you trying to run a list of the people running for governor? <g>
<ducking>
Jim Hale

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, September 04, 2003 9: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/12656914/attachment-0001.html>