Records that do not match the filter criteria in an Access 2007 linked table may be returned when you use selection filtering or the "AutoFilter" menu

When you use selection filtering or the AutoFilter menu to filter records in a Microsoft Office Access 2007 linked ODBC table, records that do not match the filtering criteria may be returned. The correct SQL statement is generated. However, some records that do not match the filter criteria are still returned.

This problem occurs when the Unique Record Identifier is set for a field that does not contain unique values.

To work around this problem, link the ODBC table to a table field that contains only unique values.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.