Database Drop-Down Is Unavailable in Add Tables Dialog Box

ID: Q141283

1.00 2.00 WINDOWS kbtool kbprb xlquery

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

KBCategory: kbtool kbprb KBSubcategory: xlquery

Additional reference words: 1.00 2.00 5.00 7.00 greyed out dimmed

Keywords          : xlquery 
Version           : 1.00 2.00
Platform          : WINDOWS

Last Reviewed: May 22, 1998