Maximum Indexes Reached

[Ken]

I have a database with a lot of tables. One of my main tables links to most
of the other tables. I tried to create a relationship that has Enforcce
Referential Integrity set but I receieved an error:

"There are too many indexes on the table. Delete some of the indexes on the
table and try the opertation again.

I looked at the help and see that 32 indexes are the maximum. Is there a
way to increase this or will I need to consolodate some of my tables?

Thanks.

 

[Ken Snell \(MVP\)]

The number of indices cannot be increased. You'll need to modify your table
structure by deleting some indices that are not needed (such as the
duplicate index that ACCESS creates for the primary key field if it contains
an ID, Num, etc. text string in the name -- you can just keep the Primary
Key index for this field), or by moving some fields into a separate table
that has the Primary Key field from the original table as the linking field
(foreign key) in an 1-to-1 relationship.

 

[Ken]

Thanks Ken

That is what I thought I would have to do.

 

[Pat Hartman \(MVP\)]

If you truly cannot get rid of any extraneous indexes, then you will need to
move up the food chain to something like SQL Server that can handle more
relationships.