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

Steps to reproduce the problem

1. In Microsoft SQL Server Management Studio, expand the database in which you want to create a new table.
2. Right-click Tables, and then click New Table.
3. Click the Column Name field, and then type LinkID. Then, click the Data Type field, and then type int.
4. Click the Column Name field, and then type LinkDescription. Then, click the Data Type field, and then type nvarchar(10).
5. Press CTRL+S. In the Choose Name dialog box, type LinkToTable in the Enter a name for the table box, and then click OK.
6. Expand Tables, right-click LinkToTable, and then click Open Table.
7. Enter several rows into the table where the LinkID is always 70 or 200.
8. In Access 2007, click the External Data tab, click More in the Import section, and then click ODBC Database.
9. Click to select the Link to the data source by creating a linked table check box, and then click OK.
10. Click the Machine Data Source tab, select the data source that points to the database in which you created the LinkToTable table, and then click OK.
11. Click dbo.LinkToTable, and then click OK.
12. In the Select Unique Record Identifier dialog box, click LinkID, and then click OK.
13. Right-click dbo_LinkToTable in the Navigation Pane, and then click Open.
14. Click the arrow in the LinkID column header, and then click to clear the (Select All) check box. Click to select the 70 check box, and then click OK.

Back to the top