input i accessdatabase
hej jeg har et lille problem jeg ikke kan få løstfejl:
----
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/administrator/www/administrator/news_new_funk.asp, line 23
---
source:
---
<%
If Request.Form("news_text") = "" Then
Response.Redirect "news_new.asp?error_code=1"
Else
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../db/sbn.mdb")
Conn.Open DSN
strSQL = "Insert into news ("
strSQL = strSQL & "news_text, "
strSQL = strSQL & "news_poster, "
strSQL = strSQL & "news_date) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & Request.Form("news_text") & "', "
strSQL = strSQL & "'" & Session("user_id") & "', "
strSQL = strSQL & "'" & now & "')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
Response.Write "nyhed oprettet!"
End if
%>
---
håber i kan hjælpe
