Microsoft KB Archive/298106

= BUG: Access Violation Occurs in Microsoft Query on Windows 2000 =

Article ID: 298106

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Query 97, when used with:
 * Microsoft Windows 2000 Standard Edition
 * Microsoft Visual Studio 6.0 Enterprise Edition

-



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 &quot;0x0043ee38&quot; referenced memory at &quot; &quot;. The memory could not be &quot;read&quot;.

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.

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

HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\VBQuery

 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.



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:
 * 4) * Create a new datasource or query.
 * 5) * Open an existing query.

Additional query words: NT5 Win2K

Keywords: kbbug kbdtacode kbfix KB298106

-

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

© Microsoft Corporation. All rights reserved.