UpdateDB

<% ID = 1 %>
<% varName = "Ramesh Thiruchelvam" %>
<% varEmail = "ramesh_thiru@yahoo.com" %>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")

Conn.Open "DBQ=" & Server.Mappath("db.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

SQL = "SELECT fldAuto, fldName, fldEmail FROM tbl WHERE (fldAuto = " & ID & ")"

rs.Open SQL, Conn, 1, 3

rs.Fields("fldName") = varName
rs.Fields("fldEmail") = varEmail
rs.Update
%>