|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
error when update MS Access |
|
From: |
forrest |
|
Date: |
12/19/1999 1:03:19 PM |
|
IP: |
144.214.160.201 |
daer friends, i am a beginner and i am doing a project using ASP. i meet problems and hope you can help me. thanks a lot.
my problem is i cant update the table in Access97.
the code is :
<%
dbname="pass.mdb"
set objconn=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath(dbname)
objconn.open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
objconn.execute ("UPDATE students SET students.PASSWORD = 222222 where students.ID =jack")
objconn.close
%>
Error Message :
Microsoft OLE DB Provider for ODBC Drivers error 80004005
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
i have tried to use recordset method but also in vien.
<%
dbname="pass.mdb"
set objconn=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath(dbname)
objconn.open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpathset
objrs=server.createobject("adodb.recordset")
objrs.open "SELECT * FROM students",objconn,2,2
objrs.addnew
objrs("password")=222222
objrs.update
objconn.close
objrs.close
%>
Error Message :
Microsoft OLE DB Provider for ODBC Drivers error 80004005
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
i am sure the file "pass.mdb" and the directory is executable. so now i dont know what i can do.
HELP ME PLEASE !!!! thanks a lot. |
Follow Up - Re: error when update MS Access - Marco Kawollek 1/13/2000 4:44:21 AM
Follow Up - Re: error when update MS Access - Tekka 3/8/2000 4:25:35 AM
Follow Up - Provider erreur 80004005 - arnaud 7/4/2000 1:39:43 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
