SQL update

Here's my code:

<cfquery name="setNote"
datasource="#DS#" dbtype="ODBC"
username="#DSUsername#" password="#DSPassword#"
>
update Notes set note = 'test' where noteid = 1
</cfquery>

Seems simple enough, but I get this:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Yeah, I know "Access Sucks.", but this still seems like it should work, no?

If I do a "select * from notes" and cfdump the results, I see the data that is there, I just can't update it.

What am I missing here?

Larry