Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 207591 - Last Review: July 16, 2004 - Revision: 1.1
ACC2000: Table Filter Is Lost After Importing Table
This article was previously published under Q207591
Novice: Requires knowledge of the user interface on single-user computers.
When you import a table with its
Filter property set into a new Microsoft Access database, you find that the filter is no longer available. When you open the table in the new database, the
Filter button is dimmed.
Table filters are not imported with the table.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- In the Database window, click Tables under Objects. Click the Categories table, and then click Open.
- On the Records menu, point to Filter, and then click Filter By Form.
- Enter the number 3 into the CategoryID field.
- On the Filter menu, click Apply Filter/Sort.
Note that the Categories table displays only records that match the filter. - Close the Categories table. When prompted to save the changes to the design of the table, click Yes.
- Close the sample database Northwind.mdb.
- In the Database window, click New on the File menu, and then create a blank database.
- On the File menu, point to Get External Data, then click Import.
- Select the Northwind database and click Import. If you installed Access to the default location, the path is C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb.
- Select the Categories table and click OK to import the table.
- Open the Categories table.
Note that the
Apply Filter button, on the
Table Datasheet toolbar, is not available in the Categories table. On the
Records menu, you can click
Apply Filter/Sort; however, there is no criteria for the filter.
APPLIES TO
- Microsoft Access 2000 Standard Edition
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