INSERT INTO
Kan Nogen fortælle mig hvad jeg gør forkert ???I får lige det hele her:
<%Response.Buffer = True%>
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db.mdb")
Conn.Open DSN
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "INSERT INTO resultater ( Navn, Email, Adresse, City, Postnr ) "
strSQL = strSQL & " VALUES('" & Request.Form("navn") & "','" & Request.Form("adr") & "','" & Request.Form("postnr") & "','" & Request.Form("stad") & "','" & Request.Form("mail") & "')"
strSQL = strSQL
Conn.Execute strSQL
rs.Close
Set rs = Nothing
Conn.Close
Set Conn = Nothing
%>
Og Fejlen :
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access-driver] Handlingen skal bruge en opdaterbar forespørgsel.
