I&#039m trying to update a record on an Access database using ASP. Here is the query:<BR>UPDATE reps SET OrderNumber=OrderNumber + 1 WHERE RepId=5<BR><BR>It is resulting in the following error:<BR>Microsoft JET Database Engine error &#039 80040e14&#039 <BR>Syntax error in UPDATE statement. <BR><BR>Am I not handling the syntax properly? I&#039ve done a great deal of hunting but can&#039t seem to find too much documentation on this type of Update query. It seems to be correct according to Access because it works when I run this query in Access on the same database.<BR><BR>Any help would be appreciated.<BR>Blain