Susan Harkins
harkins at iglou.com
Sun May 4 12:14:13 CDT 2003
> CREATE TABLE States (State TEXT(15) PRIMARY KEY) > > > > Would someone please run this simple query in Access 2000 and Access 97 and > then open the new table > > and tell me how Jet named the index? I don't have either installed anymore. > > > > Jet 4 (Access 2002) assigns an index value type name -- for example > Index_542C89A9_F5FE_4304 -- which I don't believe earlier > > versions of Jet did -- just checking because I don't remember. > > > > This looks new to me. Seems to me, Jet always used the field's name as the > index name. > > > > Susan H. > > > _______________________________________________ > dba-OT mailing list > dba-OT at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-ot > Website: http://www.databaseadvisors.com > >