I'm stuck. Trying to update a Access Database with the following code. No errors are reported, and no records are updated. Can you see anything wrong here?
Set objConn = Server.CreateObject("ADODB.Connection")
sql="UPDATE MEMBERS SET Password = '" & strNewPassword & "' where memberID = " & memberID
on error resume next
objConn.Execute sql, RecordsAffected