BUG: Access Violation Occurs in Microsoft Query on Windows 2000 (298106)


The information in this article applies to:

  • Microsoft Query 97, when used with:
    • the operating system: Microsoft Windows 2000
  • Microsoft Visual Studio, Enterprise Edition 6.0
This article was previously published under Q298106
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

Using the Microsoft Visual Studio 6.0 version of Microsoft Query (version 8.0.0.3308) on a Windows 2000-based system, you may receive an error message similar to the following:
The instruction at "0x0043ee38" referenced memory at "<memorylocation>". The memory could not be "read".
NOTE: The memory location varies.

The error may occur while you are attempting any of the following:
  • Creating a new datasource or query.
  • Opening an existing Query.
  • Launching Microsoft Query from the User Connection Designer, which comes with Microsoft Visual Basic Enterprise Edition.
If you click Cancel in the error message box, the Visual C++ integrated development environment (IDE) will open for debugging. The IDE will display the error message:
Unhandled exception in MSQRY32.EXE: 0xC0000005: Access Violation
The problem does not occur with the Office 2000 or Office XP version of Microsoft Query (for example, version 10.0.2607.0).

RESOLUTION

To work around this problem, upgrade to the Microsoft Office 2000 or Office XP version of Microsoft Query.

You can change the version of Microsoft Query used by the User Connection Designer through the following procedure.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


  1. Click Start menu, click Run, type Regedit.exe, and then click OK.
  2. Locate the key:

    HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\VBQuery

  3. Edit the Path value of the VBQuery key to point to the Microsoft Office 2000 or Office XP version of MSQRY32.exe.

    This is typically in the folder C:\Program Files\Microsoft Office\Office. However, if Office was not installed in the default folder, you may have to use the Windows Search utility to locate the Office version of MSQRY32.exe.

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 Behavior

  1. From My Computer or Windows Explorer, navigate to the folder C:\Program Files\Common Files\Microsoft Shared\VBA.
  2. Open MSQRY32.exe.
  3. Attempt any of the following:
    • Create a new datasource or query.
    • Open an existing query.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbdtacode kbfix KB298106
©2004 Microsoft Corporation. All rights reserved.