Have you tried anything?? There are many, many tutorials online for updating records.<BR><BR>What about executing an sql statement:<BR>update tbl set fld1=' & variable1 & "'" where fldid = " & id<BR><BR>That will update only fld1.<BR><BR>
try this:<BR>strSQL = "UPDATE tablename SET TableFieldName = newValue WHERE targetRecord = " & thistargetvalue(a variable or Request object - whatever you’re using to select the appropriate record)<BR>objTable.Open strSQL, objConn<BR><BR>still kinda new to this stuff myself, but have used similar SQL statements successfully. <BR><BR>ps. ASP Won't let you "close" that table object after this use.