write data

[sara]

Hi all

I do example to write data to access and i have this error

Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. in ADOTool_ADO API.vi->ADOTool_Insert Data Get Identity.vi->ferirrigation-sensor.vi

and i dont understand what is it ?? and how i can solve it i need help please.....

thanks alot....

[alukindo]

Sara:

This means that one of your SQL queries which contains an INSERT statement has a code or syntax error. Post the query and someone may be able to help you.

Anthony

[xtal]

The most common cause of this error is naming a field/column something that is a reserved word like "time", "date", etc.