Microsoft KB Archive/171855

= ACC97: Access Violation with Multiple Queries in Progress =

Article ID: 171855

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q171855



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



SYMPTOMS
Custom databases that have multiple queries running may stop responding on Microsoft Windows NT or Microsoft Windows 2000 with the following error:

Access Violation (0xc0000005), Address (varies)

This problem typically occurs when you open a database that has a significant number of background queries running simultaneously. It can also occur during the initial phases of form loading. You may also see this error when you modify the RecordSource property of a form from within the form's Load or Activate events.



CAUSE
The internal list that Microsoft Access maintains to control access to the progress meter on the Status Bar has become corrupted.



RESOLUTION
To resolve this problem, obtain Microsoft Office 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

151261 OFF97: How to Obtain and Install MS Office 97 SR-2



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

Additional query words: pra

Keywords: kbbug kberrmsg kbfix KB171855

-

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

© Microsoft Corporation. All rights reserved.