Database Drop-Down Is Unavailable in Add Tables Dialog Box

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

To resolve this problem:

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

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

   Query