We are using Access 2007 as an interface to a SQL Database via ODBC connections. We have observed we are not able to apply filters to Date/Time columns in the tables. The sort works fine...just not filtering. A query that selects a date range works correctly as well.
These same tables filtered just fine with Access 2000.