Hi all
I tried to seperate my query update im order to define what is the
limitation for the field
becaouse i know that it is limiting for 1024 characters but i see that
can update more characters(for now checked 2000 and it works too)
so what is the limit for the field?doesnt the field name is counted or
not when giving the limitation
please advice

The theoretical limit for the number of characters in a SQL statement in
Access is around 64k. There are some other limits, such as if you use the
builder, or try putting a SQL statement in a macro (e.g. under RunSQL.)

The "too complex" error is a very generic one. Sometimes it can represent a
genuine limit, e.g. you have too many SELECTs in a UNION, or more than 100
ANDs in a WHERE clause, or queries nested more than 50 levels deep.

More often, it just means Access can't make sense of the query statement.
For example, you may have mismatched brackets, or field/table names that are
reserved words. It can be as basic as applying the wrong data type for your
criteria (e.g. omitting the # around literal dates.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"thread" <yaniv.dg (AT) gmail (DOT) com> wrote

for now i set my own limitiation for 2000 characters per field and the
rest are been cut to seperate components(means if you have x+y+z,it
will be devided to x,y,z for seperate update) and it works ok.i
thought there is more specific definition to the limitation but i
understand from you that its vary

On 26 ×*ובמבר, 15:21, "Allen Browne" <AllenBro.... (AT) SeeSig (DOT) Invalid>
wrote: