How to edit a record in the table (Using SQL command)

S T E P - 1

- We need to create a Connection:

<%

Dim oConn

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db1.mdb")

%>

S T E P - 2

- Use .Execute method to perform the SQL command:

<%

Dim strSQL

strSQL = "UPDATE member SET " & _

"'Email='" & Request.Form("Email") & _

"', Gender='" & Request.Form("Gender") & _

"', AccessLevel='" & Request.Form("AccessLevel") & _

"' WHERE MemberID='" & Request.Form("MemberID") & "';"

oConn.Execute strSQL

oConn.Close

Set oConn = Nothing

%>