Debes usar comillas simples en los campos de textos
SQL=
"UPDATE usuarios SET nombre = '" & nombre & "', apellido = '" & apellido & "', actividad = '" & actividad & "' WHERE username = '" & cookiename & "' And userpwd ='" & cookieclave & "';"
<OBJECT WIDTH=200 HEIGHT=50><PARAM NAME=movie VALUE="http://www.geocities.com/wamoretti/wamoretti.swf"><PARAM NAME=wmode VALUE=transparent><EMBED src="http://www.geocities.com/wamoretti/wamoretti.swf" wmode=transparent WIDTH=200 HEIGHT=50></EMBED></OBJECT