MSQuery: Can't Add Index to Read-Only Table

ID: Q108891

The information in this article applies to:

• Microsoft Query for Windows, version 1.0
• Microsoft Query for Windows 95, version 2.0
• Microsoft Query for Windows, version 8.0

SUMMARY

In Microsoft Query, creating an index in a read-only table results in one of the following error messages.

Microsoft Query version 1.0:

   Permission Denied.

   Can't modify the design of table '<table name>'.
   It's a read-only database.

   Can't modify the design of table '<table name>'.
   It's in a read-only database.

WORKAROUND

To create an index in a read-only file, remove the read-only attribute from the table.

MORE INFORMATION

One purpose for creating an index in a table is to help Microsoft Query find values more quickly in fields that you search or sort often. Microsoft Query looks up the location of the data in the index field. An index cannot be created in a table that is protected with a read-only status. This behavior is by design. You cannot change files that have a read-only protection.

KBCategory: kbusage kberrmsg kbtool KBSubcategory: xlquery

Additional reference words: 1.00 7.0 97 read only indices

Keywords          : kberrmsg xlquery 
Version           : 1.00,2.00,8.00
Platform          : WINDOWS

Last Reviewed: June 22, 1998