[AccessD] Query Results Too Big?

No. Using SQL Server for the list.  May move to Oracle.

Rocky

  ----- Original Message ----- 
  From: Hale, Jim 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, September 04, 2003 4:26 PM
  Subject: RE: [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



------------------------------------------------------------------------------


  _______________________________________________
  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/1f0314f5/attachment-0001.html>