Can't Add Index to Read-Only Table (108891)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Query
This article was previously published under Q108891 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.
Microsoft Query version 2.0:
Can't modify the design of table '<table name>'.
It's a read-only database.
Microsoft Query version 8.0:
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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
|---|
| Keywords: | kberrmsg KB108891 |
|---|
|