Knowledge Base

ACC2: "CREATE INDEX (SQL)" Help Topic Misleading

Article ID: 132000

Article Last Modified on 6/25/2002

Microsoft Access 2.0 Standard Edition

This article was previously published under Q132000

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

A paragraph in the "Remarks" section of the "CREATE INDEX statement(SQL)" topic in the Microsoft Access Help system reads as follows:

   You can use CREATE INDEX to create a fake index on an attached table.
   To create such an index, you don't need permission or access to the
   remote server, and the remote database will be unaware of and unaffected
   by the index. You use the same syntax for attached and native tables.

RESOLUTION

This paragraph is misleading. You can use the CREATE INDEX statement to create a fake index on an attached SQL data source table only. You cannot create a fake index on an attached Microsoft Access, Paradox, FoxPro, dBASE, or Btrieve table.

REFERENCES

For more information about creating indexes, search for "CREATE INDEX (SQL)," and then "CREATE INDEX statement (SQL)" using the Microsoft Access Help menu.

Additional query words: pseudo pseudo-index

Keywords: kbusage KB132000