>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.

Shlomo... Thanks! THANKS! THANKS!
I've just had the same problem! Why is it that "Desc" will not work?? Does it have to do with macro substitution??? who knows.. thanks again.

daniel