[AccessD] odd index problem

AHA! Eurkea! Brilliant! :) Thanks Gary.

Susan H.


> Hi Susan,
>
> Not a problem, a feature.
>
> Go to Options then Tables/Queries and see what you have in the "Auto Index
> on Import/Create" box..... I bet "ID" is listed. If so, as soon as you
> create a field with the letters "ID" in it it makes an index. Then when
you
> select the primary key it creates a second one.
>
> I've deleted all the values from that option myself as I prefer to only
have
> indexes that I choose.
>
> Gary Kjos
> garykjos at hotmail.com
>
>
>
>
>
> >From: "Susan Harkins" <harkins at iglou.com>
> >Reply-To: accessd at databaseadvisors.com
> >To: <AccessD at databaseadvisors.com>
> >Subject: [AccessD] odd index problem
> >Date: Wed, 16 Apr 2003 10:20:25 -0400
> >
> >I've noticed something weird with indexes on two different systems using
> >Access 2002 and Access 2003. When I create a primary key using the
Primary
> >Key tool, Access creates two indexes instead of one. I've tested it a
> >number
> >of times using different scenarios and I can't seem to shake it. Does
this
> >happen with anyone else? Martin checked and says no -- he only gets the
one
> >index as expected.
> >
> >Create a simple table with a couple of fields and create a primary key on
> >one of the fields. Check the indexes window. I end up with the following:
> >
> >TestID            TestID    Ascending
> >PrimaryKey    TestID    Ascending
> >
> >The index for TestID has all properties set to No. The PrimaryKey index
is
> >as it should be -- Yes, Yes, No.
> >
> >There are no other tables, no relationships, no foreign keys in the
sample.
> >Nothing else happens -- blank database, quick table... there they are.
> >
> >Susan H.
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>