>It is a VFP error....it's the general error passed when there has been an unhandled ODBC or OLE DB error. On trapping, I get some mightly weird Collection.Errors
>
>>1429 sounds like a VFP error number. You may want to try the errors collection of the connection object for any errors.

I read your other post and assume these two are related. I couldn't find anything about using the same connection for keyset or dynamic recordsets. Any of these two types require an open connection to the backend at all times. You may be getting concurrency problems with all recordsets trying to show you changes on the underlying table(s). I would suggest using different connection objects for each recordset and let OLE-DB handle the connection details.