[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 Dettman 
  To: Access Developers discussion and 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/a41c424d/attachment-0001.html>