>>>>>Hi, Naomi,
>>>>>
>>>>>Yes, I can, but it doesn't change the outcome - works locally and failed on server
>>>>>
>>>>
>>>>If you switch to VFPOleDB what error you're getting?
>>>>
>>>>Also, is directory with VFP tables is opened?
>>>>
>>>Directory is open and works fine for SQL SELECT. SQL UPDATE is an obstacle.
>>
>>Could it be that you don't have rights for UPDATE of this table under that particular login?
>No, field replacement(SQL SELECT, assignment and RSS.UPDATE) works fine.

Appears that by using
CN.EXECUTE SQLSTR
instead of
RS.OPEN SQLSTR ...

solving the issue with the error.

Thank you