[AccessD] "Query is too complex"

Julie,

  Access has some internal constraints when it's working in general.  For
example, 2048 table references or the need to compile into a 64k segment.
"Query too complex" is a result of bumping into one of those limitations.
There are a few workarounds:

1. Split the query into multiple queries (as was already suggested).

2. Reduce table and field name lengths.

3. Replace complex function calls (i.e. multiple IIF()) with user defined
functions.

4. Build up the table first in a temp table, then use a single query against
that.

  Outside of that, there is nothing you can adjust or change in Access to
work around the limitations.

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 Julie
Reardon-Taylor
Sent: Monday, July 28, 2003 3:54 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] "Query is too complex"



Hi Everyone,

Working in the 2002 version of Access.  Have a fairly large query that is
giving me problems.  We keep getting an error message that tells me the
"Query is too complex".  It worked a few days ago, until we added fourteen
more fields and now we are getting the error.  Anyone run into this before?

Also, would like to purchase the developers edition of MS-Access 2002.  Do I
have to purchase the entire Office Developer's edition?  Is it a good idea
to do so?

Thank you for any assistance you may be able to provide.


Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com