fejl i asp script

Får denne fejl i nedenstående script:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

/proshop/admin/gem_open.asp, line 36

Scriptet:


<%
If Request("mode") = "ny" then

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("db/proshop.mdb")

SQL= "INSERT INTO open (dag, klokke, maaned)"
SQL = SQL & " VALUES ('" & request.form("dag") & "','" & request.form("klokke") & "','" & request.form("maaned") & "')"

Conn.Execute (SQL)

conn.Close
Set conn = nothing
Set SQL = nothing

response.write "Åbningstider er nu oprettet."

ElseIf Request("mode") = "gem" then

navn = request.form("dag")
klokke = request.form("klokke")
maaned = request.form("maaned")

set conn = server.createobject("ADODB.connection")
path = Server.MapPath("db/proshop.mdb")
conn.Open "DBQ="& path &";DefaultDir="& path & ";Driver={Microsoft Access Driver (*.mdb)}"

SQL="UPDATE open SET "
SQL = SQL & "dag='" & dag & "', "
SQL = SQL & "klokke='" & klokke & "', "
SQL = SQL & "maaned='" & maaned & "', "
SQL = SQL & " where ID =" & Request.Querystring("ID")
'response.write sql

Set RS = Conn.Execute(SQL)  <----- Dette skulle være linie 36 ?

response.redirect ("vis_open.asp")

else
end if
%>

/cdc