|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
