FEJL
HEjsaHvorfor får jeg denne fejl ??
Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/medlemedit.asp, line 116
Det er dette kode der giver fejl:
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"data.mdb\")
SQLstmt = \"UPDATE DISTINCTROW medlem SET password = \'\" & request.form(\"password\") & \"\', navn = \'\" & request.form(\"navn\") & \"\', adresse = \'\" & request.form(\"adresse\") & \"\', Hjemmetlf = \'\" & request.form(\"hjemmetlf\") & \"\', fax = \'\" & request.form(\"fax\") & \"\', foddag = \'\" & request.form(\"foddag\") & \"\', fodmd = \'\" & request.form(\"fodmd\") & \"\', fodaar = \'\" & request.form(\"fodaar\") & \"\', uddannelse = \'\" & request.form(\"uddannelse\") & \"\', stilling = \'\" & request.form(\"stilling\") & \"\', arbejde = \'\" & request.form(\"arbejde\") & \"\', telefon = \'\" & request.form(\"telefon\") & \"\', mail = \'\" & request.form(\"mail\") & \"\', familie = \'\" & request.form(\"familie\") & \"\', interesser = \'\" & request.form(\"interesser\") & \"\', agtefalde = \'\" & request.form(\"agtefalde\") & \"\', lc = \'\" & request.form(\"lc\") & \"\' WHERE ID=\" & request.form(\"id\") & \"\"
response.write sqlstmt
Conn.Execute (SQLstmt)
conn.Close
Set conn = nothing
Set SQLstmt = nothing
Response.Redirect(\"medlemvis.asp?id=\" & request.form(\"id\"))