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?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
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)  
Old
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

izy
__________________
currently using SS 2008R2
Reply With Quote
  #3 (permalink)  
Old
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
Carlos
Reply With Quote
Reply

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