too many indexes

Posted on 2001-07-31
Last Modified: 2008-02-01
i'm running this sql:

alter table rgcnseq3_gcnseqno_mstr
add constraint rgcnseq3_rhiclsql
foreign key (hicl_seqno)
references rhiclsq1_hiclseqno_mstr

and i get the message

...too many indexes on rgcnseq3_gcnseqno_mstr...

what does this mean?
Question by:SSF
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 54

Expert Comment

ID: 6339437
Sure that the index isn't already present?
Normally I use always a DROP followed by an ADD.


LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 50 total points
ID: 6340974
Access has a limit of 32 indexes.  Are you bumping into that?  Note that it creates indexes on it's own if your using RI.


Author Comment

ID: 6341187
I think that might be it. What's RI?
LVL 54

Expert Comment

ID: 6341560
Referential Integrety, you can specify on the Relationship form.
Just check by opening the table in design mode and select Tools/Indexes.


Author Comment

ID: 6341823
thanks J and Nico!

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question