Is there 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.

[Michael Hopwood]

Look up "specifications" in help:

Max size of SQL string: 64,000 characters (approx)

Max number of fields in a recordset: 255

--
Michael Hopwood (Phobos)
"SJM" <1_*********@mol.mn> wrote in message
news:46*****************@nnrp1.ozemail.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.

[DFS]

"SJM" <1_*********@mol.mn> wrote in message
news:46*****************@nnrp1.ozemail.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.

Can you post your SQL statement with and without the 40th field?

I have a feeling you have a trailing comma after the 40th field.