Hi there, I've been pullin my hair for the last couple of days trying to update my Access database.

I can read from it no problem but for some reason my ASP page won't write to it, but instead keeps giving me error codes. Here's what I did:

<%
set DBObj = server.createobject("ADODB.connection")
DBObj.open "TaskManager", adOpenKeyset
DBObj.execute("UPDATE Calendar SET Dat = 2 WHERE Jour = Monday1 )
%>


I keep getting the error: 'Too few parameters' on the execute query line. I've tried so many different combination with no success. My system dsn is properly set since I can read with no problem...... I'm starting to loose it here. Please help.