Records can be deleted from the table in two ways. The pointer pointing to the current record is deleted.
Delete method of the Recordset object deletes the current record from the table.
where rsstudent is a variable of recordset object
Execute method of the Connection object executes an SQL statement such as insert, update and delete.
Connobject1.Execute (sql) where sql statement is a valid DELETE statement and Connobject1 is the name of a connection object.
Strdelete = ” Delete from student where age=20”
where Connect1 is a variable of connection object and strdelete is a variable name.