Try to change cursor to the client side

DB.CursorLocation = adUseClient

>Hi - we are currenty working on a VB6 SP5 front ended app with a VFP6 database. We have been quite happilly connecting to the database and opening recordsets and perform normal data operations ie. saving new records, saving edited records and deleting records... however... with one table (which we have dropped and re-created in an attempt to fix this) when we get a record set we are able to add new records ok but when we try to save an edited record we get the error "-2147217887 Multiple step OLE DB operation generated errors. Check the OLE...etc" also when we try to delete a record we get the error "-2147467259 [Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long."
>I must stress this is happening in only one table (which we have re-created to no avail)
>We have also tried creating different recordsets ie. rsTemp, rsDelete etc - here is some code...
>the connection
< snip >