Microsoft KB Archive/295238

= ACC2002: Can't Expand Table Node in the Field List of a Data Access Page =

Article ID: 295238

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295238



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
You are unable to expand one or more table nodes in the field list of a data access page.



CAUSE
You collapsed the main Tables node in the field list after having expanded one or more table nodes under it.



RESOLUTION
Refresh the field list by clicking the Refresh Field List button at the top of the field list.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior

 * 1) CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.


 * 1) Open the sample database Northwind.mdb.
 * 2) On the View menu, point to Database Objects, and then click Pages.
 * 3) Click New.
 * 4) In the New Data Access Page dialog box, click Design View, and then click OK.

NOTE: Click OK if you are prompted that you will not be able to make design changes to the data access page in Microsoft Access 2000.
 * 1) In the data access page field list, expand the Categories node to view its fields and related tables.
 * 2) Collapse the Tables node.
 * 3) Expand the Tables node to view the tables.

Note that you can no longer expand the Categories node to view its fields and related tables.

Additional query words: pra can't unable

Keywords: kbbug kbnofix KB295238

-

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

© Microsoft Corporation. All rights reserved.