这是我的一部分代码
<%
question="aaaa"
optionno=100
set connVB = server.createobject("ADODB.Connection")
connVB.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath(mBaseDir & "Messages.mdb")
connVB.execute("INSERT INTO Option (Option, QuestionID) SELECT '"& question & "' as a, " & optionno & " as b")
connVB.execute("INSERT INTO Question (Question,QuestionID) SELECT '"& question & "' as a, " & optionno & " as b")
%>
很简单的数据库，有三个表：Question(QuestionID(auto number, primary key),Question(text));
Opiton(OptionID(auto number,primary key),Option(text));
Answer(AnwerID(auto number,primary key), QuestionID, OptionID);
我准备将数据插入option表中，用了上面的那个语句，结果得到
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
而当我用同样的语句格式将数据插入question表中时(如上)，完全正常.
请问我到底在那里出错了？多谢指教！！
