ACC: How to Index an Existing Field with DAO (95/97) (141612)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q141612
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article shows you how to use Data Access Objects (DAO) to create a
compound (multiple-field) index in an existing table.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
REFERENCES
For more information about TableDefs, search for DAO collections, and
then TableDefs using the Microsoft Access Help Index.
For more information about Indexes, search for indexes, and
then creating using the Microsoft Access Help Index.
For information about how to index an existing field in Microsoft Access
2.0, please see the following article in the Microsoft Knowledge Base:
112107 ACC2: How to Index an Existing Field with DAO
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB141612 |
---|
|