odbc_exec() SQL error

[austenr]

Has anyone ever seen this error before?

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'suffix'. Make sure you have typed the name correctly, and try the operation again., SQL state S0022 in SQLExecDirect in

If so how did you resolve it? Is this an execution error or just a warning?

[Oorang]

Sounds like a syntax error. Try putting brackets around suffix and make sure that it is spelled that way in the target table.