General discussion


Too Many Indexes on one table

Hi, do you know of a way getting around this problem ? When adding a One to Many Relationship with Referential Integrity selected, this error appears

"The operation failed. There are too manyIndexes on table tblStaff. "Delete some of the Indexeson the table and try again"

There was 10 Indexes on table not including Primary Key and 22 Relationship Links with Ref Int. In Microsoft Access 95 and Access 97, a single table cannot have more than 32 indexes and direct relationships combined.That's why the error was occurring. Some Indexes in the Table have been removed, the total is now 27. But what happens if no more Indexes can be removed and more Relationship Links are required and the limit exceeds 32. Access would let me if I did not use Referential Integrity.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums