[AccessD] Union Query

Jim Dettman jimdettman at earthlink.net
Mon Mar 7 07:53:32 CST 2005


  Not on number of Unions per say, but on queries in general.  Depending on
how complex this is, you'll probably bump into one of these:

1.  Limit of 255 columns in the output.

2.  Limit of 32 tables in a query.

3.  Approx limit of 64K characters in a SQL statement.

4.  The nebulous "query too complex message" - Up until A95, queries needed
to "compile" into a single 64K segment.  Starting with A95, that limit was
removed, but it was never specified exactly what the new limit was.  You can
fall within all the other specs and still get "query too complex".  If you
do, you hitting an internal limit that has not been specified.

HTH,
Jim.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
ksklos at comcast.net
Sent: Saturday, March 05, 2005 11:01 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Union Query


Is there a limit to the number of sql statements you can have in a union
query.  I am using Access 2000.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list