«

Hello,

When I try to run the following code I get an error: "Recordset not
updatable". It is possible to show data from the same table on a webpage, so
the database name and the table nam must be correct. I 've tried several
other things, also leaving out the
adOpenDynamic, adlockOptimistic.
If I run this code as VBA in an Access database, it works without problems.

<%
const DB_NAME = "C:\ASP\eOrganizer.mdb"

Call Main

sub Main
dim cndb
dim rs

set cnDB = Server.createobject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")

cnDB.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
DB_NAME
cnDB.Open

rs.Open "tblNotes", cnDB , adOpenDynamic, adlockOptimistic
rs("notName") = "Meeting 1-2-2004"
rs.update


end sub

%>

--
Martin van Vliet, Amsterdam
tel. 020 625 62 08

Martin van Vliet wrote:
> Hello,
>
> When I try to run the following code I get an error: "Recordset not
> updatable". It is possible to show data from the same table on a
> webpage, so the database name and the table nam must be correct. I
> 've tried several other things, also leaving out the
> adOpenDynamic, adlockOptimistic.
> If I run this code as VBA in an Access database, it works without
> problems.
>
> <%
> const DB_NAME = "C:\ASP\eOrganizer.mdb"
>
> Call Main
>
> sub Main
> dim cndb
> dim rs
>
> set cnDB = Server.createobject("ADODB.Connection")
> set rs = Server.CreateObject("ADODB.Recordset")
>
> cnDB.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=" & DB_NAME
> cnDB.Open
>
> rs.Open "tblNotes", cnDB , adOpenDynamic, adlockOptimistic
> rs("notName") = "Meeting 1-2-2004"
> rs.update
>
>
> end sub
>
> %>

http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

HTH,
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"