using the UPDATE sql statement with Access Databse

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.

[monte96]

I think I answered this for you in another thread, but don't put the () around the query- if you do, you have to assign it to something. This query returns nothing so do this:


DBObj.execute "UPDATE Calendar SET Dat = 2 WHERE Jour = 'Monday1'"