[AccessD] odd index problem

FWIW I've seen that behavior in A97 too.

Jim DeMarco



-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com]
Sent: Wednesday, April 16, 2003 10:20 AM
To: AccessD at databaseadvisors.com
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


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************