I am using a design time recordset control and trying to add records. The method addRecord() doesn&#039t give any errors, However<BR>addRecord() creates a record if there are no records in the table. If there are records in the table, it updates the values for the last record in the table instead of creating a record.<BR><BR>Could anyone of you tell me if I need to set any property which makes it work properly.<BR><BR>The same works with a recordset object created at run time using Server.CreateObject("ADODB.Recordset") with AddNew() method.<BR><BR>Here&#039s the code<BR>&#060;%<BR> strSQL = "SELECT * FROM TABLE1"<BR> rstTable.setSQLText(strSQL)<BR> rstTable.open()<BR> rstTable.addRecord()<BR> rstTable.fields.setValue("Field1", value1)<BR> rstTable.fields.setValue("Field2", value2)<BR> rstTable.fields.setValue("Field3", value3)<BR> rstTable.updateRecord()<BR> rstTable.close()<BR>%&#062;<BR><BR>Thanks