It is obvious, the SQL Satement is wrong,

But I can't yet manage it the right way.

sql = "Update web Set antwort1="' & antwort1 & "' where erkennung='" & erkennung & "'"

It doesnt work too!

Can anybody help my aboout the Update Statement ?