| Knowledge Base |
Article ID: 108891
Article Last Modified on 8/15/2003
APPLIES TO
This article was previously published under Q108891
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:
Microsoft Query version 8.0:
To create an index in a read-only file, remove the read-only attribute from the table.
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.
Additional query words: 7.0 97 read only indices Can t modify the design of table MSQuery
Keywords: kberrmsg KB108891
