indexes

[Kathy]

I need to increase the number of indexes in the
relationships table screen. It sais I cannot link anymore
tables because there is too many, it asks me to delete
some to make room for new ones. But I cannot delete any
because I need them all. So how do I come out of this
problem so that I can finish my program? Please help..
Thank you
Kathy

 

[John Vinson]

I need to increase the number of indexes in the
relationships table screen. It sais I cannot link anymore
tables because there is too many, it asks me to delete
some to make room for new ones. But I cannot delete any
because I need them all. So how do I come out of this
problem so that I can finish my program? Please help..
Thank you
Kathy

You are limited to 32 indexes on each table. There is no way around
this limit using Access. If you have a "sea urchin table" with
enforced relationships to more than 32 tables you're in trouble - but
such a relationship structure would be VERY unusual.

Doublecheck your table's Indexes collection: Access is quite capable
of creating redundant, unneeded indexes! For instance, any field whose
name ends in ID or NO or NUM is indexed automatically; if you then
create a second index (such as a Primary Key on the ID field), you end
up with BOTH indexes. Delete any redundant indexes. Also, any (yuck,
PTOOOIE!) Lookup Fields will create an extra index, again even if
there is one there already. Finally, you can often take advantage of
multifield indexes - for instance, you don't often need separate
indexes on LastName, FirstName and MiddleInitial; you can create a
three-field nonunique index to make any search which includes the last
name as a criterion more efficient.