Solved

too many indexes

Posted on 2001-07-31
5
261 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

809 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