在添加记录的时候出现了Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] 不能更新。数据库或对象为只读。的错误,?
<%
database = "data\users.mdb"
StrConnect = "Driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath(database)
Set Conn=Server.CreateObject("ADODB.Connection")
conn.Open StrConnect
userid=request.form("userid")
name=request.form("name")
sex=request.form("sex")
email=request.form("email")
address=request.form("address")
if address="" then
address="不详"
end if
if name<>"" and edit<>"添加" then
sql="select * from users"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs.addnew
rs("userid")=userid
rs("name")=name
rs("sex")=sex
rs("email")=email
rs("address")=address
rs.update
database = "data\users.mdb"
StrConnect = "Driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath(database)
Set Conn=Server.CreateObject("ADODB.Connection")
conn.Open StrConnect
userid=request.form("userid")
name=request.form("name")
sex=request.form("sex")
email=request.form("email")
address=request.form("address")
if address="" then
address="不详"
end if
if name<>"" and edit<>"添加" then
sql="select * from users"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs.addnew
rs("userid")=userid
rs("name")=name
rs("sex")=sex
rs("email")=email
rs("address")=address
rs.update
...全文
相关推荐
Provider错误80004005终极解决方法(完全有效的方法)
IIS设置好之后打开ASP网站时总提示: Microsoft OLE DB Provider for ODBC Drivers 错误 ‘80004005’ [Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 ‘Temporary (volatile) Jet DSN for process 0x728 Thread 0x854 DBC 0x276fb44 Jet’, ********************************************************************************** P
Access数据库不能写不能更新的解决方法
本文提供了Access数据库不能写不能更新的解决方法,主要是权限原因,具体看下面的具体解决方法
数据库或对象为只读
数据库或对象 错误提示:不能更新。数据库或对象为只读为只读
Asp常见的连接access数据库的错误
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x914 Thread 0xb44 DBC 0x1f50064 Jet'。
IIS常见问题解答集锦
ASP 程序运行时提示: Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'


