SQL statement too large?

[Joshn]

Is there a max number of characters a SQL statement can
have? I have a complicated SQL statement with a nested
query holding an INNER JOIN of a couple of tables, then a
couple more in the main query.

The query executes fine but I need one more field.
Everytime I add an extra field anywhere in the queryset
(from any of the tables) I get an "error in the FROM
clause". The error message resolves once I remove a field,
any field.

Thanks for any help as to what to check out to diagnose
the problem.
Josh

 

[Allen Browne]

From the Access 2003 specifications for queries:

Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 gigabyte
Sort limit 255 characters in one or more fields
Number of levels of nested queries 50
Number of characters in a cell in the query design grid 1,024
Number of characters for a parameter in a parameter query 255
Number of ANDs in a WHERE or HAVING clause 99
Number of characters in an SQL statement approximately 64,000