Too many indexes

G

Guest

I went back and added some fields to a table. Then, when I tried to save it,
it said "Too many indexes". How do I get rid of indexes? Can I get out of
this without rebuilding the entire table?
 
K

Ken Snell \(MVP\)

Open the table in design view. Click on the "lightning bolt" icon (Indexes)
on toolbar to see all the indices that exist for the table. Delete the ones
you don't need.
 
B

Brendan Reynolds

In addition to Ken's good advice, you might also be interested to know that,
by default, Access creates indexes on fields that either end with or begin
with the following groups of letters: "ID", "key", "code" and "num". You can
control this option by selecting Options from the Tools menu, selecting the
Tables/Queries tab in the Options dialog box, and editing the list in the
text box labelled 'AutoIndex on Import/Create'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Many Indexes Bug 5
Too Many Indexes Error 3
Too many indexes 10
File Size Spiralling Out of Control (Continued) 1
Too many indexes 3
Don't understand the relationship between a combo box and a table 15
too many indexes 1
Linking to Sybase Tables - Too many indexes issue 2

Top