asp 访问 ACCESS 数据库时报错！

[deanetg]

我进行INSERT INTO 操作。
但是，总是报错：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 操作必须使用一个可更新的查询。

我的连接没问题。而且字段等均没问题。
请专家指导。

我的机器：
WINDOWS XP
IIS 5.1
ACCESS 2000

[Luckyji]

可能是语句漏写或者错误导致的错误检查一下！！

[dicklee1214]

代码？

[yangsm]

把代码贴出来吗？

[deanetg]

dim ConnectionString,oleConnection,sqlText,dataPath,oleRst,htmltext
dim username,nikename,password,sex,work,mail,city,certid,address,postid,phone,productname,productid
dataPath = server.MapPath("database/database.mdb")
ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & dataPath

set oleConnection = server.CreateObject("ADODB.Connection")
set oleRst = server.CreateObject("ADODB.recordset")
oleConnection.ConnectionString=ConnectionString

oleConnection.Open




username = request.Form("username")
nikename = request.Form("nikename")
password = request.Form("password")
sex = request.Form("sex")
work = request.Form("work")
mail = request.Form("mail")
city = request.Form("city")
certid = request.Form("certid")
address = request.Form("address")
postid = request.Form("postid")
phone = request.Form("phone")
productname = request.Form("productname")
productid = request.Form("productid")

if sex = "true" then
sex = 1
else
sex = 0
end if

replace username,"'",""""
replace nikename,"'",""""
replace password,"'",""""
replace work,"'",""""
replace mail,"'",""""
replace city,"'",""""
replace certid,"'",""""
replace address,"'",""""
replace postid,"'",""""
replace phone,"'",""""
replace productname,"'",""""
replace productid,"'",""""


sqlText = "select * from userinfo where nikename='" & nikename & "'"



olerst.Open sqltext,oleConnection,3,3


if olerst.RecordCount<>0 then

htmltext = "此用户昵称已经被其他用户注册，请重新选择一个昵称。"
else
htmltext = ""


end if



olerst.Close()


if htmltext = "" then
sqlText = "INSERT INTO userinfo(username,nikename,gender,pwd,email,city,worker,certid,addr,postid,phone,productname,productid) VALUES ('"_
& username & "','"_
& nikename & "','"_
& sex & "','"_
& password & "','"_
& mail & "','"_
& city & "','"_
& work & "','"_
& certid & "','"_
& address & "','"_
& postid & "','"_
& phone & "','"_
& productname & "','"_
& productid & "')"



set rs = oleConnection.Execute(sqlText)

response.Write sqlText





oleconnection.Close
htmltext = "您已经成功注册！ "
session("UserName") =nikename
end if

[gshope]

在该access文件的属性里允许internet用户对它有写的权限。

[孟子E章]

数据库是否是只读了

[xiaocainiaolong]

http://expert.csdn.net/Expert/TopicView1.asp?id=2285026

[007james]

数据库是否被其他文件以独占形式打开或其他方式打开了，也或者是只读呢？

[deanetg]

我用recordset.addnew 的方法可以添加数据，但是用insert into就不行！！！

[61]

检查Access数据库文件的安全属性权限

[netying]

应该是权限的问题，不要是只读的

[dafei0320]

打开数据不要是只读！~
设置好游标的类型！！~~！
！~！

[zat1978]

recordset对象的locktype应该是3才能添加