If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > PC based Database Applications > Microsoft Access > "Too many indexes on table", delete some and try again error?

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Dec 2004
Posts: 9
"Too many indexes on table", delete some and try again error?

hello, I am need some help. I have a database in which everything ties into the main table. I have a large of amount of constraints to enforce reference integerity and cascasde delete opeation. I have it set so whenever the main item is deleted, all its children will be deleted. There are 160 child tables! I am not half way through and now access tells me that It can not index the main table anymore and delete some of the indexes? I need a way to fix these or help with a better design. I am very tight deadline!!!
Reply With Quote
  #2 (permalink)  
Cavalier King Charles
Join Date: Dec 2002
Location: Préverenges, Switzerland
Posts: 3,739
a2k help says:
Number of indexes in a table 32
Number of fields in an index 10

currently using SS 2008R2
Reply With Quote
  #3 (permalink)  
Registered User
Join Date: Sep 2004
Location: Rio Bravo, Mexico
Posts: 27
izy, I think what he is refering to is that he can not link any more child tables to main due to too many indexes.

skurge, what you need to do is to go into each of the child tables (design mode) and click on the index icon (lightning icon) and delete any of the indexes that are no going to be used. I had the same problem once and this did the trick.

hope this helps
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On