Hai, <BR>I am trying to update a field in a table. The SQL statement that I have given belowreturns only one record. As you could see, I have set the mode as readwrite mode and also the DSN is not set to Read-only. But still, I get an error saying "Cannot update. Database or object is read-only". What else Should I change? <BR>Code is: <BR>set conn=server.createobject("adodb.connection") <BR>conn.Mode = adModeReadWrite <BR>myDSN="DSN=K12.dsn;uid=;pwd=" <BR>conn.open myDSN <BR>SQL="SELECT * from Comments WHERE Topic='1' AND Sub='1'" <BR>Set RS = Server.CreateObject("ADODB.RecordSet") <BR>RS.Open SQL, conn, 3, 3, 1 <BR>rec=RS.RecordCount <BR>Response.Write " count is " & rec <BR>RS("EMail")="firstname.lastname@example.org" <BR>RS.Update <BR><BR>Thanks in advance.