Microsoft KB Archive/95929

{|
 * width="100%"|

PRB: Error in Database Analyzer: DTSysQuery Already Exists
'Article ID: Q95929

Creation Date: 01-MAR-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0 and 1.1

SYMPTOMS

When you are using the Database Analyzer, you click the Analyze button and receive the error message:

DTSysQuery already exists CAUSE

The Database Analyzer often creates a temporary query called DTSysQuery to complete certain tasks. When the Database Analyzer finishes using DTSysQuery or needs to create one, it first deletes the current copy. If it cannot delete DTSysQuery, it attempts to create DTSysQuery anyway because it assumes DTSysQuery does not exist. As a result, an error occurs in the Database Analyzer and the error message you see is the result of a generic error trap mechanism that forwards the Access Basic error to the user.

One reason why the Database Analyzer fails to delete the existing copy of DTSysQuery is because the Database Analyzer is installed on a drive or directory that has read-only permissions.

RESOLUTION

To prevent the error from occurring, follow these steps:


 * 1) Open the MSACCESS.INI file in Notepad. This file is usually located in your Windows directory.
 * 2) Locate the section called [Libraries].
 * 3) Place a semicolon in front of the entry for ANALYZER.MDA.
 * 4) Close and save MSACCESS.INI. Then restart Microsoft Access.
 * 5) Open the database called ANALYZER.MDA.
 * 6) In the database window, delete the DTSysQuery query. Quit Microsoft Access.
 * 7) Repeat steps 1 and 2. Then remove the semicolon from the front of the entry indicated in step 3.
 * 8) Restart Microsoft Access and try the Database Analyzer again.

If the Database Analyzer is located on a drive or directory that does not have modify permissions, you may not be able to complete step 6 successfully. Even if you can, the problem will likely recur. If it does, move the Database Analyzer to a drive or directory that has modify permissions.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10

KBCategory: kbusage

KBSubcategory: GnlOthr