Microsoft KB Archive/322046

= XL2000: Edit Query Dialog Box Disappears When You Edit Oracle Query =

Article ID: 322046

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q322046



SYMPTOMS
When you use Microsoft Query in Microsoft Excel, and you try to edit a query that accesses data in an Oracle database, the Edit Query dialog box appears briefly and then disappears.



WORKAROUND
To work around this issue, use a System Data Source Name (DSN) instead of a File DSN when you set up your connection to the database.

For additional information about how to create and use System DSNs, click the article numbers below to view the articles in the Microsoft Knowledge Base:

213772 XL: How to Use System, User, and File Data Sources

300595 HOW TO: Create a System Data Source Name (DSN) in Windows 95, Windows 98, or Windows NT

300596 HOW TO: Create a System Data Source Name (DSN) in Windows 2000

305599 HOW TO: Create a System Data Source Name in Windows XP

Additional query words: XL2000 excel msquery qry vanish missing visible gone

Keywords: kbnofix kbprb KB322046

-

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

© Microsoft Corporation. All rights reserved.