Access97: Max # of indexes?

  • Thread starter Thread starter XMan
  • Start date Start date
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.
 
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.
 
Back
Top