[AccessD] Fw: [dba-OT] favor -- about index names

Susan 
In A97 it fails and I had to recode as 

CREATE TABLE States (State TEXT(15) CONSTRAINT PrimaryKey PRIMARY KEY)

so no question about index name as I had to give one.

In A2K it worked. the index name was "Index_5F808805_DE92_4A13" which is
quite catchy I'm sure you'll agree.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Susan Harkins
> Sent: 04 May 2003 18:14
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Fw: [dba-OT] favor -- about index names
> 
> 
> 
> 
> > 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
> >
> >
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>