Specifikt problem med En SQL sætning i ASP, op imod en Access DB
Dette script vil ikke skrive til min Access Database.Hvorfor ikke?
--------------------------------------------------------
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../db/IDarkiv.mdb")
Conn.Open DSN
strSQL = "Insert into IDarkiv ("
strSQL = strSQL & "Password, "
strSQL = strSQL & "Efternavn, "
strSQL = strSQL & "Fornavn, "
strSQL = strSQL & "Adresse, "
strSQL = strSQL & "Postnr, "
strSQL = strSQL & "By, "
strSQL = strSQL & "Mail, "
strSQL = strSQL & "Telefon) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'Kode', "
strSQL = strSQL & "'Hansen', "
strSQL = strSQL & "'Henning', "
strSQL = strSQL & "'Kattevej 27', "
strSQL = strSQL & "'6000', "
strSQL = strSQL & "'Haderslev', "
strSQL = strSQL & "'henninghansen@hotmail.dk', "
strSQL = strSQL & "'88888888')"
Conn.Execute(strSQL)
'Luk databaseforbindelse
Conn.Close
Set Conn = Nothing
%>
--------------------------------------------------------
