Insert lort
Er der nogen der kan se hvorfor jeg for nedenstående fejl?<%
Dim sql
Set Conn = Server.CreateObject("ADODB.connection")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("database\hjsas.mdb")
sql = "INSERT INTO Bestilling (Firmanavn,Adresse1,Adresse2,Postnr,City,Telefon,Telefax,Email,Bestillingsdato,Bestillingsnavn,Kontonr,Leveringsonske,Antal1,Varenr1,varebetegnelse1,Antal2,Varenr2,varebetegnelse2,Antal3,Varenr3,varebetegnelse3) VALUES ('"&Request.Form("firma")&"','"&Request.Form("adresse1")&"','"&Request.Form("adresse2")&"',"&Request.Form("postnr")&",'"&Request.Form("bynavn")&"',"&Request.Form("telefon")&","&Request.Form("telefax")&",'"&Request.Form("email")&"',"&Request.Form("bestilt_dato")&",'"&Request.Form("bestilt_af")&"',"&Request.Form("kontonr")&","&Request.Form("lev_dato")&","&Request.Form("Antal1")&","&Request.Form("varenr1")&",'"&Request.Form("varebet1")&"',"&Request.Form("Antal2")&","&Request.Form("varenr2")&",'"&Request.Form("varebet2")&"',"&Request.Form("Antal3")&","&Request.Form("varenr3")&",'"&Request.Form("varebet3")&"')"
Conn.Execute(sql)
Conn.close
Set Conn = Nothing
%>
<% Response.Redirect "index.html" %>
Fejlen er::
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/jonas/hjsas/hub.asp, line 9
