Operation must use an updateable query Error

[Ray P.]

Group,

On a W2K3 / IIS 6.0 Server, we have a Web Site reading
an .mdb fine. When it tries to save, it generates the
following error:

Microsoft OLE DB Provider for ODBC Drivers
error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.

/web/version_1.9/admin/updateinfo.asp, line 24

I've search high and low in TechNet.
I did implement this item with no help.

[url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
us;830977

Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
dim Message,ttl
Message = request.form("bodytxt")
Message = Replace(Message,"""","""",1,-1,vbTextCompare)
Message = Replace(Message,"'","''",1,-1,vbTextCompare)
ttl = request.form("hometitle")
ttl = Replace(ttl,"""","""",1,-1,vbTextCompare)
ttl = Replace(ttl,"'","''",1,-1,vbTextCompare)

' Connect to database

set objconn=Server.CreateObject ("ADODB.Connection")
'response.write objconn.mode
'objconn.mode = 3

objconn.open "Driver={Microsoft Access Driver (*.mdb)};
DBQ="& Server.MapPath ("ihldb\ihldb.mdb")
'objconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="& Server.MapPath ("ihldb\ihldb.mdb")

' Update Database

sqlstr="UPDATE home SET hometitle='"&ttl&"',
homedesc='"&Message&"',homeimg='noimg' WHERE
homeid="&request.form("infoid")
'response.write sqlstr
Set objrs=objconn.Execute(sqlstr)

response.redirect("admin_index.asp")

%>

[Bob Barrows]

Ray P. wrote:

> Group,
>
> On a W2K3 / IIS 6.0 Server, we have a Web Site reading
> an .mdb fine. When it tries to save, it generates the
> following error:
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
>

This is not the cause of this particular problem, but you should stop using
the obsolete ODBC drivers, using the native Jet OLEDB provider instead. See
here: [url]www.able-consulting.com/ado_conn.htm[/url]

> [Microsoft][ODBC Microsoft Access Driver] Operation must
> use an updateable query.

Your answer will very likely be found in one of these articles:
[url]http://www.aspfaq.com/show.asp?id=2062[/url] - updatable cursor
[url]http://www.aspfaq.com/show.asp?id=2009[/url] - 80004005 errors

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[GVaught]

Permissions are set incorrect at the server level.

"Ray P." <ray@paganini.com> wrote in message
news:0e8401c3b683$51766330$7d02280a@phx.gbl...

> Group,
>
> On a W2K3 / IIS 6.0 Server, we have a Web Site reading
> an .mdb fine. When it tries to save, it generates the
> following error:
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Operation must
> use an updateable query.
>
> /web/version_1.9/admin/updateinfo.asp, line 24
>
> I've search high and low in TechNet.
> I did implement this item with no help.
>
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
> us;830977
>
> Code:
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <%
> dim Message,ttl
> Message = request.form("bodytxt")
> Message = Replace(Message,"""","""",1,-1,vbTextCompare)
> Message = Replace(Message,"'","''",1,-1,vbTextCompare)
> ttl = request.form("hometitle")
> ttl = Replace(ttl,"""","""",1,-1,vbTextCompare)
> ttl = Replace(ttl,"'","''",1,-1,vbTextCompare)
>
> ' Connect to database
>
> set objconn=Server.CreateObject ("ADODB.Connection")
> 'response.write objconn.mode
> 'objconn.mode = 3
>
> objconn.open "Driver={Microsoft Access Driver (*.mdb)};
> DBQ="& Server.MapPath ("ihldb\ihldb.mdb")
> 'objconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source="& Server.MapPath ("ihldb\ihldb.mdb")
>
> ' Update Database
>
> sqlstr="UPDATE home SET hometitle='"&ttl&"',
> homedesc='"&Message&"',homeimg='noimg' WHERE
> homeid="&request.form("infoid")
> 'response.write sqlstr
> Set objrs=objconn.Execute(sqlstr)
>
> response.redirect("admin_index.asp")
>
> %>