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 Article ID : 924743 Last Review : October 15, 2007 Revision : 1.3
On This Page 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 "Applies to" 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 .
APPLIES TO • Microsoft Office Access 2007
Other Support Options Need More Help? Customer Service Newsgroups
Help and Support
Back to the top
