ASP Failing to Update Access Database?

The Form (manageLinks2.asp)
<FORM action="linkUpdate.asp" method="post">
<table>
<tr>
<td>LID</td>
<td>Name</td>
<td>URL</td>
<td>Weight</td>
</tr>
<tr>
<td><input name="linkID" type="text" disabled="disabled" size="2" value="<%= rsEdit("LinkID") %>" /></td>
<td><input name="linkName" type="text" size="30" value="<%= rsEdit("LinkName") %>" /></td>
<td><input name="linkURL" type="text" size="30" value="<%= rsEdit("LinkURL") %>" /></td>
<td><input name="linkWeight" type="text" size="2" value="<%= rsEdit("LinkWeight") %>"  /></td>
</tr>
</table>
<input type="submit" />
</FORM>
 
The Submission Page (linkUpdate.asp)
 
<%
Set conn = server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("../sfsDb.mdb")
conn.Open DSNtemp
 
 
SQLstmt = "UPDATE Links SET "
SQLstmt = SQLstmt & "LinkName='" & TRIM(Request.Form("linkName")) & "', "
SQLstmt = SQLstmt & "LinkURL'" & TRIM(Request.Form("linkURL")) & "', "
SQLstmt = SQLstmt & "LinkWeight" & TRIM(Request.Form("linkWeight"))
SQLstmt = SQLstmt & " WHERE LinkID=" & TRIM(Request.Form("linkID"))
 
conn.Close
Set conn = nothing
Set SQLstmt = nothing
 
'Return to the update select page in case another record needs deleting
Response.Redirect "manageLinks2.asp"
%>