简单问题 急需解决~就一个SQL语句
conn.Execute( "update   admin   set   password= ' "&newpassword& " '     where   username= 'admin ' ")
我想修改admin表里   admin这个管理员的密码
怎么一直提示我UPDATE   语句的语法错误。  

大家救救我

------解决方案--------------------
conn.Execute( "update admin set password= ' "&newpassword& " ' where username= 'admin ' ")
password为系统关键字,要加方括号

conn.Execute( "update admin set [password]= ' "&newpassword& " ' where username= 'admin ' ")
------解决方案--------------------
楼上正解.
------解决方案--------------------
对的，照上面做
------解决方案--------------------
conn.Execute( "update admin set password= ' "&newpassword& " ' where username= 'admin ' ")
password为系统关键字,要加方括号

conn.Execute( "update admin set [password]= ' "&newpassword& " ' where username= 'admin ' ")

他都回答了....
------解决方案--------------------
又来晚了
conn.Execute( "update admin set [password]= ' "&newpassword& " ' where username= 'admin ' ")