• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

too many indexes

i'm running this sql:

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

and i get the message

...too many indexes on rgcnseq3_gcnseqno_mstr...

what does this mean?
0
SSF
Asked:
SSF
  • 2
  • 2
1 Solution
 
nico5038Commented:
Sure that the index isn't already present?
Normally I use always a DROP followed by an ADD.

Nic;o)

0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.

Jim.
0
 
SSFAuthor Commented:
JDettman,
I think that might be it. What's RI?
0
 
nico5038Commented:
Referential Integrety, you can specify on the Relationship form.
Just check by opening the table in design mode and select Tools/Indexes.

Nic;o)
0
 
SSFAuthor Commented:
thanks J and Nico!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now