Im having general problems trying to UPDATE records. The results I have been getting are "adding" of records, using rs.AddNew <BR><BR>If anybody could help that would be great!<BR><BR>I am assuming that, the way to update specific records would be isolating records with some kind of SQL statement. Wich i am doing. I either have an incorrect SQL statement, or my assumption is incorrect.<BR><BR>please advise! any help is super appreciated..<BR><BR>-George<BR><BR><BR> <BR>sample code below---<BR><BR>set rs = server.createobject("adodb.recordset")<BR>rs.lockt ype = adopenkeyset<BR>rs.locktype = adlockoptimistic<BR> "user where Username=&#039"&user&"&#039", db, , , adcmdtable<BR><BR>--------<BR><BR>ive done the above with no avail. IM DESPERATE!!<BR><BR>:)<BR><BR><BR><BR>