Access97: Max # of indexes?

X

XMan

I've got an error message saying that there are too many indexes on one of
the tables. What's maximum # of indexes per table for Access97? TIA.
 
D

Douglas J. Steele

It's 32. Check in the Help file under "Specifications, Microsoft Access",
then Read About Table Specifications.

Note that relationships always add indexes, so it's possible you might have
some duplicated.
 

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

Insert Index into a Table 1
maximum number of indexes per SQL table that Access (jet) can dealwith? 0
access97 to 2002 search button conversion error 2
Too Many Indexes Bug 5
Error opening Access97 on new Windows XP User 3
Too Many Indexes: 16? 5
Damaged Outlook 2010 file prevents indexing. Am I doing the right repairs? 0
index when to add 4

Top