Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

No Tables Appear in Add Tables Dialog Box


View products that this article applies to.

This article was previously published under Q164383

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


Resolution

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

↑ Back to the top


Status

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

↑ Back to the top


Keywords: KB164383, kbualink97, kbbug

↑ Back to the top

Article Info
Article ID : 164383
Revision : 6
Created on : 1/19/2007
Published on : 1/19/2007
Exists online : False
Views : 557