Quote Originally Posted by si_the_geek View Post
Welcome to VBForums

There is a good chance that Position is a reserved word, and if so should not be used as a field/table name (it confuses the query parser within the database system). If you change the name (in the database and your code), it is likely to work correctly.
that was it! caused the trouble. thank you. problem solved