Editing foxpro tables for update using VFPOLEDB.1

I am getting this error when I open a recordset for updating. Here is
the error and code:

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation
of the provider, or of the selected locktype.

mySql = "select * from jobs where id =" & JobId
rs.maxrecords = 1
rs.open mySql,Conn,2,2
With Rs
.Fields("status") = status
.fields("from") = from
End with
rs.close

Yes, I know I should have used sql queries instead of recordsets, but
when using inserts or updates with memo fields I would get errors for
anything bigger than 254 bytes, but not with recordsets. That's why I
used recordsets in the first place. And now I have hundreds of pages
just like that, and it will take sometime for me to change them all, so
please advice on how to fix this problem.

Thanks,
Osi.