Solved

too many indexes

Posted on 2001-07-31
5
262 Views
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
(hicl_seqno);

and i get the message

...too many indexes on rgcnseq3_gcnseqno_mstr...

what does this mean?
0
Comment
Question by:SSF
  • 2
  • 2
5 Comments
 
LVL 54

Expert Comment

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

Nic;o)

0
 
LVL 57

Accepted Solution

by:
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.

Jim.
0
 

Author Comment

by:SSF
ID: 6341187
JDettman,
I think that might be it. What's RI?
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6341560
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
 

Author Comment

by:SSF
ID: 6341823
thanks J and Nico!
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

837 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