I have a simple Query running through a webpage for MS Access DB. it bombs out. couldnt find any info. anyone out there seen this problem. I am using Dev Edition of MX7.

--------------------------------------------------------------------------------------------------------------

the query is

UPDATE text
SET text_1='#text_1#', text_2='#text_2#', text_3='#text_3#', text_4='#text_4#'
WHERE (text_id = #text_id#)

--------------------------------------------------------------------------------------------------------------

The error i get is

Error Executing Database Query.
Syntax error in UPDATE statement.

The error occurred in C:\Inetpub\wwwroot\Websites\bio\admin\submit_form.cfm: line 5

3 : UPDATE text
4 : SET text_1='#text_1#', text_2='#text_2#', text_3='#text_3#', text_4='#text_4#'
5 : WHERE (text_id = #text_id#)
6 : </cfquery>
7 : </cfif>

SQL UPDATE text SET text_1='qwe', text_2='qwe', text_3='qwe', text_4='' WHERE (text_id = 2)
DATASOURCE biodefense
VENDORERRORCODE 3092
SQLSTATE  
Please try the following:

* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.

--------------------------------------------------------------------------------------------------------------

Any Help is welcome