Operation must use an updateable query
Jeg får fejlen :Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Ved at køre nedenstående script :
<%
Function jflFix (txt)
txt = Replace(txt, \"\'\", \"\'\'\")
txt = Replace(txt, \"|\", \"\")
jflFix = txt
End Function
If Not (Request.Form(\"Navn\") = \"\" And Request.Form(\"Adresse\") = \"\" And Request.Form(\"Postnr\") = \"\" And Request.Form(\"By\") = \"\" And Request.Form(\"Email\") = \"\") Then
DBPath = \"DBQ=\" & server.mappath(\"db/murer.mdb\")
Set Dbc = Server.CreateObject(\"ADODB.Connection\")
Dbc.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; \" & DBPath
SQL = \"INSERT INTO konkurrence (Navn, Adresse, Postnr, Bysted, Email, Kommentarer) VALUES (\'\" & jflFix(Request.Form(\"Navn\")) & \"\', \'\" & jflFix(Request.Form(\"Adresse\")) & \"\', \'\" & jflFix(Request.Form(\"Postnr\")) & \"\', \'\" & jflFix(Request.Form(\"By\")) & \"\', \'\" & jflFix(Request.Form(\"Email\")) & \"\', \'\" & jflFix(Request.Form(\"Kommentarer\")) & \"\')\"
Dbc.Execute(SQL)
Dbc.Close
Set Dbc = Nothing
End If
%>
Jeg har bedt administratoren om at lave skriverettigheder, men ligemeget hjalp det ?
