Microsoft KB Archive/188805

= ACC: Table Filter Is Lost After Importing Table =

Article ID: 188805

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q188805



Novice: Requires knowledge of the user interface on single-user computers.



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



CAUSE
By design, table filters are not imported with the table.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb. On the Tables tab, 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.</li> Close the sample database Northwind.mdb.</li> In the Database window, click New Database on the File menu, and then create a blank database.</li> On the File menu, point to Get External Data, then click Import.</li> Select the Northwind database and click Import. If you installed Access to the default location, the path is:

Access 7.0:

<pre class="fixed_text">         C:\MSOffice\Office\Samples\Northwind.mdb

Access 97:

<pre class="fixed_text">         C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb

</li> Select the Categories table and click OK to import the table.</li> Open the Categories table.</li></ol>

Note that the Apply Filter button is disabled in the Categories table.

Additional query words: imported

Keywords: kbprb KB188805

-

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

© Microsoft Corporation. All rights reserved.