Is there a limit to sql string length

[SJM]

In some VBA code I am building an SQL string to append a new record to a
table. The string involves 40 fields. What I am finding is that it works
with 39 fields but when I add 40 it fails with the error 3134 (syntax
error). I am 99% sure there is no syntax error, rather I suspect that it
could be due to limit on string length or number of fields. I have not been
able to find anything that defines this though.

[Lyle Fairfield]

"SJM" <1_*********@mo l.mn> wrote in
news:%H******** *******@nnrp1.o zemail.com.au:

In some VBA code I am building an SQL string to append a new record to a
table. The string involves 40 fields. What I am finding is that it works
with 39 fields but when I add 40 it fails with the error 3134 (syntax
error). I am 99% sure there is no syntax error, rather I suspect that it
could be due to limit on string length or number of fields. I have not
been able to find anything that defines this though.

from AcXP help

Access Specifications

**** begin quote ****

Query

Attribute Maximum
Number of enforced relationships 32 per table minus the number of indexes
that are on the table for fields or combinations of fields that are not
involved in relationships 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

**** end quote ****

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[TC]

Sorry, it is 99.99% likely to be a syntax error.

debug.print the "bad" SQL string, & post the result here.

HTH,
TC
"SJM" <1_*********@mo l.mn> wrote in message
news:%H******** *******@nnrp1.o zemail.com.au.. .

In some VBA code I am building an SQL string to append a new record to a
table. The string involves 40 fields. What I am finding is that it works
with 39 fields but when I add 40 it fails with the error 3134 (syntax
error). I am 99% sure there is no syntax error, rather I suspect that it
could be due to limit on string length or number of fields. I have not been able to find anything that defines this though.