i used your example and just adjusted it for some extra stuff.<BR><BR>conn1.Execute "UPDATE safsdest_params SET paramdata = '" & mypassword & "' WHERE destid = '" & myname & "' and paramdata = '" & myoldpassword & "'" <BR><BR>i get no errors from this but it doesn't update the field in that table. any more suggestions ? thanks for all your help.
Your sql looks OK. Are you sure that myname and myoldpassword have the correct values? You might want to response.write them to make sure. I'd also do a view|source to see what it reveals. It looks to me as though you're just not isolating the correct record(s). If you'd misspelled one of the field names, you should get an error.