Microsoft KB Archive/924743

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

Article ID: 924743

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-



SYMPTOMS
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.



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



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



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



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.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbbug kbprb kbexpertiseinter KB924743

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.