When trying to setup a one-to-many relationship with referential integrity, I get the following error Message:
The operation failed. There are too many indexes on table tblClientInfo. Delete some of the indexes and try again.
The ‘Help’ button has the following message:
The operation failed. There are too many indexes on table <name>. Delete some of the indexes on the table and try the operation again. (Error 3626)
A table in a Microsoft Jet database can have no more than 32 indexes. You cannot create additional indexes on a table with this many indexes. Further, you cannot compact a database containing a table with this many indexes because compacting a database involves creating several new indexes.
Delete one or more indexes from the named table and try the operation again.
I tried to compact the database and it compacted fine – which surprised me because the help section said it shouldn’t compact.
When I list the indexes through the documenter, there are 13 listed. The table specs say I can have 32.
I do have several one-to-many relationships set on this table, is there a limit to relationships? I can’t find one listed in the specifications.
Please Help
The operation failed. There are too many indexes on table tblClientInfo. Delete some of the indexes and try again.
The ‘Help’ button has the following message:
The operation failed. There are too many indexes on table <name>. Delete some of the indexes on the table and try the operation again. (Error 3626)
A table in a Microsoft Jet database can have no more than 32 indexes. You cannot create additional indexes on a table with this many indexes. Further, you cannot compact a database containing a table with this many indexes because compacting a database involves creating several new indexes.
Delete one or more indexes from the named table and try the operation again.
I tried to compact the database and it compacted fine – which surprised me because the help section said it shouldn’t compact.
When I list the indexes through the documenter, there are 13 listed. The table specs say I can have 32.
I do have several one-to-many relationships set on this table, is there a limit to relationships? I can’t find one listed in the specifications.
Please Help