I have a recordset which contains 10 records. when i delete the fourth row using the delete method of the recordset, the row from the actual table is also getting deleted. how can i delete the row only from recordset and not from the actual table. any help?