ACC2002: System Crash or Hang When You Drag an Unrelated Child Table into a Parent Section of a Data Access Page (295206)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295206
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

When you drag an unrelated child table into a parent section of a data access page, you may experience an operating system crash or hang, depending on the operating system that you are running.

RESOLUTION

Avoid dragging an unrelated child table into a parent section of a data access page.

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. Start Microsoft Access, and then open the sample database Northwind.mdb.
  2. Create a new data access page in Design view.
  3. If the field list is not displayed, click Field List on the View menu.
  4. In the field list, expand the Categories table. Drag the CategoryName field into the unbound section of the data access page.
  5. In the field list, expand the Products table. Drag the ProductName field onto the data access page underneath the Categories section to create a child section.
  6. In the field list, expand the Order Details table. Drag the UnitPrice field onto the data access page into the Products header section. Note that placing the UnitPrice field into the Products section resets the recordset for this section. Note also that the header for the section changes.
  7. Drag the entire Products table from the field list into the Categories section of the data access page. Be sure to drag the entire Products table. At this point, note that multiple sum aggregates on the count of ProductID are created and continue to be created until you experience a system hang or crash, depending on the operating system that you are running.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug kbpending KB295206
©2004 Microsoft Corporation. All rights reserved.