[AccessD] "Query is too complex"

There is a limit in the total number of fields you can have in a query.
I've even seen this error in earlier versions of Access when using less
than 32 fields in a single-table query where every field in the table
was a 255 char width text field.

There is no developers edition of Access, only an Office Developer
version in 2002, so you'll have to purchase the MOD upgrade.

Charlotte Foust

-----Original Message-----
From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] 
Sent: Monday, July 28, 2003 11:54 AM
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