[AccessD] odd index problem

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