Hi Bill,

Take a look at PRB: Problems with Visual FoxPro Driver "Fetch Data In Background" Option mskb #Q269881. It doesn't look directly related to you proble but is wirth a try. If you've VFP7 you can also try to use VFP OLE DB provider.

>Sergey,
>I didn't set up the connection, but I'm thinking it's ODBC. This is the ASP connection code:
> Set conn = Server.CreateObject("ADODB.connection")
> conn.Open session("session_dsn")
>where, I believe, session_dsn is the ODBC dsn connection name.
>
>>Bill,
>>
>>Are you using OLE DB provider for ODBC or VFP OLE DB provider?
>>
>>>Hi All,
>>>We get the following error for a second (or third) update using rs.update in ASP script connected to VFP database thru ADO.
>>>
>>>Error:
>>>"Row cannot be located for updating. Some values may have been changed since it was last read."
>>>
>>>Hitting the browser refresh will send it through correctly, but that's a poor work-around :^)
>>>
>>>It's a problem with ADO's Query By Update method of creating an "Action query", which gets confused on the second rs.update to the same record. But how can the action query be controlled, or otherwise fixed?
>>>
>>>The SQL UPDATE mytable SET ... works great since it doesn't create an action query, but we have to use the QBU method to use AppendChunks, don't we?
>>>
>>>I hope somebody has solved this one - Thanks!