h*****l
发帖数: 184 | 1 我用ASP处理ACCESS数据库。
但运行INSERT时，出来错：
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use
an updateable query.
百思不得其解， 请帮我看看， 错误出在SQLInsert那句上：
Set corConn = Server.CreateObject("ADODB.Connection")
dbpath = Server.mappath("fpdb\mbaalumni.mdb")
corConn.open "driver={Microsoft Access Driver (*.mdb)}; dbq=
"&dbpath&""
RS = Server.CreateObject("ADODB.Recordset")
SQLSel = "Select * from mbaalumni Where fname = '"&
Request.Form("fname") | N**e
发帖数: 158 | 2
try to print the query out here, if it's right(no empty fields, no bad values)
then double check the table format.
I suspect it's the .Form call that cause the problem
【在 h*****l 的大作中提到】
: 我用ASP处理ACCESS数据库。
: 但运行INSERT时，出来错：
: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
: [Microsoft][ODBC Microsoft Access Driver] Operation must use
: an updateable query.
: 百思不得其解， 请帮我看看， 错误出在SQLInsert那句上：
: Set corConn = Server.CreateObject("ADODB.Connection")
: dbpath = Server.mappath("fpdb\mbaalumni.mdb")
: corConn.open "driver={Microsoft Access Driver (*.mdb)}; dbq=
: "&dbpath&""
|
|
