Microsoft KB Archive/295206

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

Article ID: 295206

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

Additional query words: pra data access page dap aggregate sum hang crash

Keywords: kbbug kbpending KB295206

-

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

© Microsoft Corporation. All rights reserved.