Are there other inserts working for this table? possible that the table name itself is causing the problem, since ORDER is [part of] an ANSI SQL keyword (ORDER BY)?
I remember one time I was working with a field which held a description, and we were getting errors until we renamed it to "descr" instead of "desc" :roll:
Hope this is the problem, because it seems like it would be simple to fix...
-- Jon