asp高手求助错误类型:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。/newgn/exa5.asp, 第 14 行<%set conn=server.createobject("adodb.connection")conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/cnbruce.mdb")name=request.form("name")psw=request.form("psw")email=request.form("email")question=request.form("question")answer=request.form("answer")oicq=request.form("oicq")icq=request.form("icq")msn=request.form("msn")url=request.form("url")exec="insert into user([name],psw,email,question,answer,oicq,icq,msn,url)values('"+name+"','"+password+"','"+email+"','"+question+"','"+answer+"',"+oicq+",'"+icq+"','"+msn+"','"+url+"')"conn.execute exec //第14行conn.closeset conn=nothingresponse.write "记录添加成功!"%>
參考答案:(第十三行)user也是关键字,要用[user]