sql error

[level200]

I am building a simple form that feeds into an access database, i have done the same thing many times without a problem. All of a sudden i am now getting an error message:

SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement..


I have set the access database to accept null, but am still getting the error.


Can anyone please help.

[Carl Shepherdson]

http://www.xlinesoft.com/asprunner/docs/error_syntax_error_in_insert_into_statement.htm

[Mark Voss]

Are you using a field name that is a reserved word?

[level200]

Hmmm good point, fields:

image

text

wonder if the name 'text' is the problem

[Mark Voss]

Possibly - text IS a reserved word (http://support.microsoft.com/kb/209187)

[level200]

Sorted, cheers guys :thumbup1: