I keep getting this error: 
----------------------------------------------
UPDATE tblusers SET username ='jason', user_fullname ='Jason Bucknera', 
WHERE user_ID =2

Error #-2147217900

Error desc. -> [Microsoft][ODBC Microsoft Access Driver] Syntax error in 
UPDATE statement.
----------------------------------------------

Here is my code:
---------------------------------------------
<%
on  error resume next
form_username=request.form("username")
form_user_fullname=request.form("user_fullname")
form_ID=request.form("ID")

myDSN="DSN=PharmCharges;uid=;pwd="
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open myDSN

' change apostrophe to double apostrophe
form_name=Replace(form_name, "'", "''")
IF  instr(lcase(form_name),"<img")>0 THEN
   form_name=""
END IF

SQLstmt = "UPDATE tblusers SET " &_
	"username ='" & form_username & "', " &_
	"user_fullname ='" & form_user_fullname & "', " &_
	" WHERE user_ID =" & form_id

Set RS = Conn.Execute(SQLStmt)
%>

Try writing your SQL statement like this:

SQLstmt = "UPDATE" _
          & " tblusers" _
          & " SET" _
          & " username = '" &form_username & "',user_fullname = '" 
&form_user_fullname & "' WHERE user_ID = " & form_ID 

ww

> I keep getting this error: 
-> ---------------------------------------------
U> PDATE tblusers SET username ='jason', user_fullname ='Jason Bucknera', 
W> HERE user_ID =2

> Error #-2147217900

> Error desc. -> [Microsoft][ODBC Microsoft Access Driver] Syntax error in 
U> PDATE statement.
-> ---------------------------------------------

> Here is my code:
-> --------------------------------------------
<> %
o> n  error resume next
f> orm_username=request.form("username")
f> orm_user_fullname=request.form("user_fullname")
f> orm_ID=request.form("ID")

> myDSN="DSN=PharmCharges;uid=;pwd="
S> et Conn = Server.CreateObject("ADODB.Connection")
c> onn.open myDSN

> ' change apostrophe to double apostrophe
f> orm_name=Replace(form_name, "'", "''")
I> F  instr(lcase(form_name),"<img")>0 THEN
 >   form_name=""
E> ND IF

> SQLstmt = "UPDATE tblusers SET " &_
	> "username ='" & form_username & "', " &_
	> "user_fullname ='" & form_user_fullname & "', " &_
	> " WHERE user_ID =" & form_id

> Set RS = Conn.Execute(SQLStmt)
%

My problem was that I had a comma before the where statement! Thanks.