How to assign value into recordset?

[knockyo]

Welcome to VBForums

After setting the field value(s), you need to specify that you want to write those values to the database, which you do with: rs.Update
(or cancel the changes with: rs.CancelUpdate)

hi, thanks your reply.

after the code Rs("LastReadDate") = Now, it jump to the excepetion error.

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done