Max # of fields in a query?

From: Suzanne Knapp (sc.knapp_at_verizon.net)
Date: 01/02/05 

Date: Sun, 02 Jan 2005 00:54:41 GMT

How many fields are allowed in a query? When I tried to make a query which
would include all fields in every table (to use as the basis of a group of
forms), I got an error message "too many fields". I don't need all of these
fields in any one form, but it's simpler to have only one query as the forms
are being developed. I have plenty of RAM and disk space - can the number
be configured to be larger?

Relevant Pages

  • SQL-Server Licensing and Web Apps?
    ... what if multiple queries are launched at the same time from different ... Thus, if 5 users submit a query at the same time, does ... No matter how many query processes are running, ... still only so much RAM and bus bandwidth available. ...
    (microsoft.public.sqlserver.setup)
  • Re: apache process going wild...
    ... I have a small FreeBSD 6.3 R server with 1Go of RAM and 5Go of swap. ... X enviroment, just the basic PHP5, apache 2 and Berkley DBXML database ... enables request on the data passing XML queries. ... that a simple query translate sometime in a 130-140Mb of RAM used by one ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Microsoft Access Queries to an Oracle DB run 4 times slower in XP than Win98
    ... If Windows XP needs more RAM to run efficiently, there will be less RAM for ... If you can't do that you may be able to restructure your query and report. ... When we upgraded from running Win98 to Windows XP Professional (ver ... SP2) the queries times degraded significantly. ...
    (microsoft.public.access.queries)
  • new additional ram card is not being recognised by computer.
    ... with a query as basic as the one I pose below. ... There are two orange slots and two purple RAM slots on MBoard. ... the card cutouts to hold it. ... Comp does not recognise the new additional 1GB of PC World ram. ...
    (uk.comp.homebuilt)
  • Re: Number of servers required to process half TB of data
    ... runs into half a terabyte. ... select query on this amount of data would be to have it all in RAM. ... half terabyte of RAM, spread across perhaps 32 computers, working over ...
    (microsoft.public.sqlserver)