[AccessD] Indexes

Martin, are you after the length of the indexes name? 

Susan H. 

AFAIK, there is no way to get the "length" of an index.  There is certainly
no property in DAO or ADO to return it.  Neither the Field.FieldSize nor the
Field.Size properties are valid with an Index field.

A lot would depend on exactly how Access stores indexes and I suspect that
information is proprietary.  In particular, I doubt that the indexing scheme
for text fields uses a fixed length based on the maximum length of a text
field, it's more likely to be storing some hash of the the text, so even
tracking back to the TableDef.Fields collection and the lengths of the
individual fields in the index is unlikely to return the correct answer.










--
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.2/349 - Release Date: 5/26/2006