Try and paste the same instruction (recordset.source) into the query analizer, it's easier to trap the error that way, you can copy it from the debugger. I do something like x = object.recordset.source, and I have created a form to display the value of x in an editbox (It's easier to copy form there), anyway HTH.

>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!!!!