急，添加删除的问题，求高人救命！

[wolf11th]

Application.Lock
Set Conn = Server.CreateObject("Adodb.Connection")
StrConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Sever.MapPath ("db.mdb")
Conn.Open StrConn
query="delete from product where productID='aaa'"
'query="select * from product"
Conn.execute(query)
Conn.close
response.write query
Application.Unlock

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 无法从指定的数据表中删除。

但是我用select语句却可以正常通过，这到底是怎么回事啊？
搞了三个多小时都不知道什么毛病。小弟初学asp，请高人指教啊

[「已注销」]

Set Conn = Server.CreateObject("Adodb.Connection")
StrConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Sever.MapPath ("db.mdb")
Conn.Open StrConn
query="delete from product where productID='aaa'"
'query="select * from product"
Conn.execute(query)
Conn.close
response.write query

1，去掉 对application的Lock和unlock
2，测试时用 query="select * from product where productID='aaa'"来看会不会有错误

[TaoTaoYou]

query="delete from product where productID='aaa'"

Query="Delete * Form product where productID= 这里注意如果值为数值则：productID="&aaa

如果是字符串：productID="&aaa&""