Please, post the code line that gives this error.

>>>Yor message below
ARRRRGG!!

I'm using VFP 6 SP4 with ADO and SQL 7. When I try to update one of the SQL tables with the ado recordset it returns the following error.

OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'values'...

I have tried EVERYWAY I can to try to track down this bug but I have about given up hope. Does ANYONE have ANY IDEAS of what this may be or even what I could do to narrow down the problem??

TIA!!!!