>rs.Open , , , adLockOptimistic
>Now when a user in working with a record of this recordset and underlined table gets changed he gets an error message "Can't locate a cursor for update. Source was changed."
>How can I avoid this situation?

You can use adLockPessimistic but this will lock more than one record (not only the one being edited).