[AccessD] Indexes

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/> 




More information about the AccessD mailing list