[AccessD] odd index problem

Susan,

Have a look at the settings you have in
Tools->Options->Tables/Queries->AutoIndex On Import/Create...

HTH,
Shamil

----- Original Message -----
From: "Susan Harkins" <harkins at iglou.com>
To: <AccessD at databaseadvisors.com>
Sent: Wednesday, April 16, 2003 6:20 PM
Subject: [AccessD] odd index problem


> 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