[AccessD] Query Results Too Big?

Which list this list?... I've heard of firebird SQL, has anyone here acctually used it? (wondering)....

http://firebird.sourceforge.net/

-- 
-Francisco



Rocky Smolin - Beach Access Software wrote:

> No. Using SQL Server for the list.  May move to Oracle.
>  
> Rocky
>  
>
>     ----- Original Message -----
>     *From:* Hale, Jim <mailto:jim.hale at fleetpride.com>
>     *To:* 'Access Developers discussion and problem solving'
>     <mailto:accessd at databaseadvisors.com>
>     *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
>         <mailto: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
>          
>