Here is the answer, ... I found it.

it depends on the order in the SQL statement of the columns;: SQL = Select id, first name, name, answer1, .... ...

I can only see rs("id"), rs("answer7"), rs("time")

but not rs("first name"), rs("name"),rs("answer1"), rs("answer2"), .....

on the web site

what ist SSMS ?

Thanks.

First I inserted the first name and name with insert into the table .

ql= "INSERT INTO web(first name ,name,... )VALUES('" & first name & "','" & name...

I found the right SQL Statement.

sql = "Update web Set answer1='" & answer1 & "'" & " where identity=" & identity

Thanks a lot for your replies.

SQL...

identity is just a normal column, not the identifier, I know, it is probalbly not right to use this word as an normal column, since it it reserved as identifier....

I am trying out:

Actually

sql = "Update web Set answer1='" & answer1 & "' where identity='" & identity & "'"

Gives the error message with

Response.Write (SQL)

Response.End

Update...

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='" &...