Onderwerp: sql / access database error

Hallo,

Iemand enig idee hoe ik onderstaande error zou kunnen oplossen
____

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

/app/admin/admin.asp, line 201

_____


Stukje van de asp-code

____

If u_action <> "add" then



select case u_action

case "insert"

sql = "insert into news (title,body,author,insert_date)"

sql = sql & " values( '" & u_title & "' , '" & u_body & "' , '" & u_author &
"' , #" & u_date & "#)"


case "display"

sql="select * from news where id="&u_id

case "delete"

sql="delete from news where id="&u_id

case "edit"

sql="select * from news where id="&u_id

case "logout"

session("password") = ""

case "update"

u_id=request.form("u_id")

sql = "UPDATE news SET title='" & u_title & "',"

sql = sql & " body='" & u_body & "',"

sql = sql & " insert_date=#" & u_date & "#,"

sql = sql & " author='" & u_author & "'"

sql = sql & " WHERE id="&u_id

case else

sql="select * from news order by insert_date desc "

end select



accessdb="../db/db_sdp.mdb"

cn="driver={Microsoft Access Driver (*.mdb)};"

cn=cn & "dbq=" & server.mappath(accessdb)

Set rs = Server.CreateObject("ADODB.Recordset")

(Line 201) rs.Open sql, cn


Op deze laatste regel gaat hij fout....

Groetjes

Wilbert

het sql statement bij de update (net voor de fout)=

UPDATE news SET title='test 8', body='test 8', insert_date=#9-1-2003#,
author='' WHERE id=1