Microsoft KB Archive/141283

= Database Drop-Down Is Unavailable in Add Tables Dialog Box =

Article ID: 141283

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q141283





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.



WORKAROUND
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.

