请捉BUG......
源程序如下:
question1=Request.Form ("question")
strProvider="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\") & "\pub1.mdb;"
set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
Response.Write question
cm.CommandText ="ALTER TABLE alphardquestion ADD "&question1&" char(20)"
cm.Execute
执行错误提示:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access 驱动程序] 字段定义语法错误
我将
cm.CommandText ="ALTER TABLE alphardquestion ADD "&question1&" char(20)"
中"&question1&"改成任意指定名称如:job,则正常。请各位大侠指教!!