Microsoft KB Archive/164383

= No Tables Appear in Add Tables Dialog Box =

Article ID: 164383

Article Last Modified on 1/19/2007

-

APPLIES TO


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

-



This article was previously published under Q164383



SYMPTOMS
When you attempt to query a Microsoft Access database using Microsoft Query or the Get External Data command in Microsoft Excel, the Add Tables or Choose Columns dialog box may appear blank.

You may also receive the following error message:

This data source contains no visible tables.



CAUSE
This problem occurs if you use a Microsoft Access database and a folder with the same name in the same directory. For example, the Add Tables or Choose Columns dialog boxes appear blank if a folder named "Northwind" and a Microsoft Access database named "Northwind.mdb" exist in the same directory, as in the following example:

C:\Program Files\Microsoft Office\Office\Samples\Northwind

C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb



RESOLUTION
To resolve this problem, do not use a folder and a Microsoft Access database with the same name in the same directory.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: empty MSQuery

Keywords: kbbug kbualink97 KB164383

-

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

© Microsoft Corporation. All rights reserved.