Knowledge Base

Query98: "Table Does Not Exist..." Error Adding Index to Locked Table

Article ID: 188011

Article Last Modified on 9/11/2002

Microsoft Excel 98 for Macintosh
Microsoft Query 2000

This article was previously published under Q188011

SYMPTOMS

In Microsoft Query 98 Macintosh Edition, when you try to add an index to a table, you may receive the following error message:

Table does not exist:<hard drive name>:<path>:<table name>

CAUSE

You may receive this error if the table for which you are trying to create the index is locked.

RESOLUTION

To create the index successfully, unlock the table. To do this, follow these steps:

In Finder, locate and select the table.
On the File menu, click Get Info.
In the Info window, clear the Locked check box.
Close the Info window.

STATUS

This behavior is by design of Microsoft Query 98 Macintosh Edition.

Additional query words: XL98

Keywords: kbprb KB188011