How many indexes can a table have?

[cani]

I have a database that holds information concerning several companies. Each company has several company-specific tables plus there are common tables. When a company is set up the database automatically creates all company specific tables, primary keys, indexes, etc., plus relationships with the existing common tables.

After a certain point, I receive a message that a certain table has too many indexes and that I should delete the related tables or remove the indexes.

Does anyone know how many indexes Access permits on a particular table?

 

[RickSpr]

It depends on the version. Try looking in the help file for "specifications". For Access 97, under Table Specifications, it gives "Number of indexes in a table: 32". Rick Sprague

 

[MichaelRed]

Hmmmmmmmmmmmmmmmmm,

I don't know a specific number of indicies, but there is a limit of 255 "Fields" - with the strange caveat that indicies (in some manner) coutribute to the number of 'Fields'. A further 'consideration' is that the number of indicies has a DRAMATIC effect on data manipulation (add/edit/[delete?]) records. So if your are encountering these limits, you should do a thorough review of the database structure. If you feel this is beyond your capability, seek the help of someone w/ more experience.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over