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.
 
Top