INSERT Error

  • Thread starter Thread starter T Cordon
  • Start date Start date
T

T Cordon

Im updating a remote Access database using a Web Service.

First I drop all the records in the table and then I insert the records in
the DataSet received by the webservice.

Most of the tables update ok but some give me this error. The
databases/tables have exactly the same structure.

-2147217900 Syntax error in INSERT INTO statementet.

This insert statement is being generated by a OleDBCommandBuilder,

Please need Help

Thanks
 
I thing I see the problem... Reserved word ( USER ) for one of the fields

do I have to change the Field name or can I fix it and still use the
OleDBCommandBuilder?

Thanks
 
I think it will, but reserved words are more pain than they are worth,
change it now IMHO, or you'll meet it again along the road soemwhere
 
Back
Top