Check Box Again Again Part 2

Hey There

I have an asp page that updates an insert in my database
however I am getting this error
Microsoft OLE DB Provider for ODBC Drivers error \'80040e07\'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/mediascope/admin/edit_save_news.asp, line 22


my script looks like this

<%

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


SQLstmp = \"UPDATE DISTINCTROW news SET dato = #\" & Now & \"#, news_name = \'\" & request.form(\"news_name\") & \"\', news = \'\" & request.form(\"news\") & \"\', authour = \'\" & request.form(\"authour\") & \"\', email = \'\" & request.form(\"email\") & \"\', publish = \'\" & request.form(\"publish\") & \"\' WHERE Id = \" & Request(\"Id\")
Conn.Execute (SQLstmp)



conn.Close
Set conn = nothing
Set SQLstmp = nothing

response.redirect (\"main_news.asp\")
%>

line 22 is this
Conn.Execute (SQLstmp)

however the last insert in the SQLstmp
is a colume called publish and it is a check box, the script works fine if I dont have publish

should publish have some sort of
\"if blah blah then blah blah\"
statement ??

Guzzie