Martin Reid
mwp.reid at qub.ac.uk
Fri Jun 2 09:43:45 CDT 2006
Susan Was looking the length of Index. Was looking at a bit of code to check the Index lengths before moving to SQL Server 2005. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Susan Harkins Sent: Fri 02/06/2006 15:35 To: 'Access Developers discussion and problem solving' Subject: Re: [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 <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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>