Yes, the where clause is not a problem. The SQL statements that I have been writing are not the problem. But there is a significant difference between the results that I receive from Access versus my ODBC connection. In my last example, I added a new record to the database. It appears in the Access database, yet it is not accessable via ODBC