in reply to MS Access/ODBC error: why??

Most certainly it's because of an apostrophe in one of your values.

unfortunately your posting is very difficult to read as you didn't use <code> tags