Syntax Error HJÆLP

Hejsa

Jeg bruger disse 2 filer til at vise og rette noget data, men jeg får en syntaks fejl..

UPDATE DISTINCTROW eqequip SET char = \'Fleetfoot\', surname = \'Test\', level = \'03\' WHERE id = 7
Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'

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

/mt/eqequipgemret.asp, line 17

Fil 1

<html>
<head>
<title></title>
</head>
<body>

<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"mt.mdb\")
SQLstmt = \"SELECT * FROM eqequip WHERE id = \" & Request(\"id\")
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>

<center>
<a href=\"mainadmin.asp\">Tilbage til Administration</A>
<br>
<form method=\"POST\" action=\"eqequipgemret.asp?id=<%=rs(\"id\")%>\">
<table width=\"95%\" cellpadding=\"5\" cellspacing=\"0\" border=\"1\" bordercolor=\"#000000\">
<tr>
<td width=\"30%\" valign=\"top\"><b>Charname</b></td>
<td width=\"70%\" valign=\"top\"><input name=\"char\" size=\"50\" value=\"<%=rs(\"char\")%>\"></td>
</tr>
<tr>
<td width=\"30%\" valign=\"top\"><b>Surname</b></td>
<td width=\"70%\" valign=\"top\"><input name=\"surname\" size=\"50\" value=\"<%=rs(\"surname\")%>\"></td>
</tr>
<tr>
<td width=\"30%\" valign=\"top\"><b>Level</b></td>
<td width=\"70%\" valign=\"top\"><input name=\"level\" size=\"50\" value=\"<%=rs(\"level\")%>\"></td>
</tr>
</table>
<br>
<input type=\"submit\" value=\"Send\">
</form>

<%
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>

</center>
</body>
</html>

Fil 2

<%
response.buffer = true
%>

<html>
<head>
<title></title>
</head>
<body>

<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"mt.mdb\")
SQLstmt = \"UPDATE DISTINCTROW eqequip SET char = \'\" & request.form(\"char\") & \"\', surname = \'\" & request.form(\"surname\") & \"\', level = \'\" & request.form(\"level\") & \"\' WHERE id = \" & Request(\"id\")
response.write sqlstmt
Conn.Execute (SQLstmt)
conn.Close
Set conn = nothing
Set SQLstmt = nothing
response.redirect (\"eqequipadmin.asp\")
%>

</body>
</html>


HJÆLP!!!

Med venlig hilsen
Søren