为什么在asp中对access数据库用insert和delete语句会出错?
我在asp中对access数据库进行插入和删除操作会出错,
set conn=server.createobject("adodb.connection")
conn.open"dsn=zhangduo"
set rs=server.createobject("adodb.recordset")
sql="delete from orderonline where 姓名='xxx'"
rs.open sql,conn,3
运行时,报错如下:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
用insert语句时,报错如下:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query
而我用select语句则正常执行。这是为什么呢?