Microsoft KB Archive/295238

From BetaArchive Wiki

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.

MORE INFORMATION

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