Microsoft KB Archive/295226

= ACC2002: Resource Leak When You Use the Query Designer in an Access Project (ADP) =

Article ID: 295226

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295226



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

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you use the query design grid to modify a query in a Microsoft Access project (.adp) file, you eventually run out of system resources. Then, you may experience one or more of the following symptoms:  Microsoft Windows returns the following error message:

Ninety percent or more of your system resources are in use. To free up system resources, quit any programs that you are not using. If you do not, your computer may stop responding.

 Microsoft Access returns the following error message:

The parameter is incorrect.

 You receive an invalid page fault in Kernel32.dll.



CAUSE
The query designer leaks system resources when you continuously click to select and click to clear the check boxes in the field list, or when you constantly switch between Design view and other views of the query.



RESOLUTION
To free up system resources consumed by the query designer, quit and then restart Microsoft Access. If a large amount of resources have been consumed, you may have to restart your computer.



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
CAUTION: If you follow the steps in this example, you modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and follow these steps on a copy of the project.

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

NOTE: The following steps assume that you are running Microsoft Windows 98 or Microsoft Millennium Edition (Me).
 * 1) Click Start, point to Programs, point to Accessories, point to System Tools, and then click Resource Meter. Note that the Resource Meter icon appears in the Windows system tray on the taskbar.

NOTE: If the Resource Meter is not available, you can install it from the Windows Setup tab in the Add/Remove Programs tool in the Control Panel.
 * 1) Start Microsoft Access.
 * 2) Double-click the Resource Meter icon in the Windows system tray on the taskbar to view the Resource Meter.
 * 3) Resize the Access application window so that you can view the Resource Meter and Access at the same time.
 * 4) Open the sample project NorthwindCS.adp.
 * 5) Close the Main Switchboard form if it appears.
 * 6) On the View menu, point to Database Objects, and then click Queries.
 * 7) Click the Invoices view in the Database window, and then click Design.
 * 8) Click to clear the check boxes next to several fields in each table to remove them from the view's output.
 * 9) On the View menu, click Datasheet View.
 * 10) Click Yes when Microsoft Access prompts you to save the view. This runs the view and displays the results in Datasheet view.
 * 11) On the View menu, click Design View.
 * 12) Click to select the check boxes next to several fields in each table to add them to view's output.
 * 13) On the View menu, click Datasheet View.
 * 14) Click Yes when Microsoft Access prompts you to save the view. This runs the view and displays the results in Datasheet view.
 * 15) Look at the current values in the Resource Meter. Note that System Resources and GDI Resources have both decreased.
 * 16) Repeat steps 9 through 16 several times.

Note that System and GDI Resources decrease each time. If you continue this cycle repeatedly, Windows will eventually run out of system resources, and you may experience one or more of the symptoms that are mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kberrmsg kbbug kbnofix KB295226

-

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

© Microsoft Corporation. All rights reserved.