Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 924743 - Last Review: October 15, 2007 - Revision: 1.3
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.
Steps to reproduce the problem
- In Microsoft SQL Server Management Studio, expand the database in which you want to create a new table.
- Right-click Tables, and then click New Table.
- Click the Column Name field, and then type LinkID. Then, click the Data Type field, and then type int.
- Click the Column Name field, and then type LinkDescription. Then, click the Data Type field, and then type nvarchar(10).
- Press CTRL+S. In the Choose Name dialog box, type LinkToTable in the Enter a name for the table box, and then click OK.
- Expand Tables, right-click LinkToTable, and then click Open Table.
- Enter several rows into the table where the LinkID is always 70 or 200.
- In Access 2007, click the External Data tab, click More in the Import section, and then click ODBC Database.
- Click to select the Link to the data source by creating a linked table check box, and then click OK.
- 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.
- Click dbo.LinkToTable, and then click OK.
- In the Select Unique Record Identifier dialog box, click LinkID, and then click OK.
- Right-click dbo_LinkToTable in the Navigation Pane, and then click Open.
- 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.
APPLIES TO
- Microsoft Office Access 2007
| kbtshoot kbbug kbprb kbexpertiseinter KB924743 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate