Database Drop-Down Is Unavailable in Add Tables Dialog Box

ID: Q141283

The information in this article applies to:
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for Windows 95, version 2.0

SYMPTOMS

The Database drop-down is unavailable (shaded) in the Add Tables dialog box in Microsoft Query even though there is more than one database in that directory.


CAUSE

This problem occurs when the default database is set in the ODBC data source, but the default directory is set to a different directory than the default database.

WORKROUND

NOTE: Because there are several versions of Windows, the following steps may be different on your computer. If they are, please consult your product documentation to complete these steps.

To resolve this problem, follow these steps:
  1. In Control Panel, open the ODBC dialog box.


  2. In the Data Sources dialog box, select the ODBC driver you are having problems with (Access 2.0 for example), and click the Setup button. Note the path for the database that is displayed above the select button.


  3. Click the Advanced button and make sure that the default directory in the options group is the same as the one in that you noted in Step 2.



REFERENCES

"User's Guide," version 5.0, Chapter 23, "Retrieving Data with Microsoft Query"

For more information about Microsoft Query, click the AnswerWizard tab in Microsoft Excel 7.0 Help, type the following text

Query
and click the Search button.

For more information about Microsoft Query, choose the Search button in Microsoft Excel 5.0 Help and type:
Query

Additional query words: 5.00 7.00 greyed out dimmed

Keywords : xlquery
Version : WINDOWS:1.0,2.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 6, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.