THanks Rick,
I found the problem. One of the fields in the table had a reseved name ("desc") which was the field that modidied and cause the "Syntax Error"
the minute I change the field name in the source table to "xDesc" all worked fine.