Microsoft KB Archive/158932

= ACC95: Main Form with Two-Level Nested Subforms Causes Error on Windows NT =

Article ID: 158932

Article Last Modified on 7/1/2002

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q158932



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you use the Filter By Form command on a form with two nested subforms, and you move between main form records, you may receive an error message similar to the following:

An application error has occurred and an application log is being generated.

MSACCESS.EXE

Exception: access violation (0xc0000005), Address: 0x500b96e1



RESOLUTION
The only workaround is to avoid the circumstances that cause the error:


 * If you use two levels of nested subforms in a database on Microsoft Windows NT, don't use the Filter By Form command.
 * If you must use the Filter By Form command with two levels of nested subforms, then run the command on a computer running Windows 95.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 7.0. This problem no longer occurs in Microsoft Access 97.



Steps to Reproduce Problem
WARNING: Following these steps will cause an invalid page fault on your computer. Make sure you save and close any open work on your computer before following these steps.


 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Customers form in Design view.
 * 3) On the Window menu, click Tile Vertically so that you can see both the form and the Database window.
 * 4) Drag the Orders form from the Database window to the bottom of the detail section of the Customers form. Because the Orders form already contains a subform, this creates two levels of nested subforms on the Customers form.
 * 5) On the View menu, click Form.
 * 6) On the Records menu, point to Filter, and then click Filter By Form.
 * 7) Type T* in the Customer ID field on the Customers form.
 * 8) On the Filter menu, click Apply Filter/Sort.
 * 9) Use the record navigation buttons at the bottom of the Customers form to move through the main form records. Note that the error occurs.

NOTE: You may have to move through two or more records to generate the error.

Additional query words: IPF msaccess exe invalid page fault watson

Keywords: kberrmsg kbbug kbfix kbusage KB158932

-

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

© Microsoft Corporation. All rights reserved.