Indexes in Access Table

[oni1983]

I am trying to add more fields to my table but I am being told that I have reached the maximum of 32 indexes. However when I go to Show/Hide group to check what fields are indexed only 3 show. Does this mean that there are many other indexes which are hidden?

I have also removed the option for Access to autoindex fields unless their name contains ID.

If so, is there a way I can unhide and delete them? I have no need for so many indexed fields...the 3 index which show are enough to suit my needs.

 

[xenou]

Some relevant info (possibly) here:
database design - Getting around the 32-relationship-per-table limit in Access - Stack Overflow

 

[oni1983]

Thanks for the link. However my issue is with the 'hidden' indexes created by the database itself. Could it be that many of the fields of the table in question require the user to choose from a drop down list (the information being generated from another table through a relation)?

 

[xenou]

I would guess that it is possible that the tables in question have lookups in them. Whether or not this requires users to choose from a drop down I'm not sure (I personally would never include lookups of any kind in TABLE objects).

 

[oni1983]

I would guess that it is possible that the tables in question have lookups in them. Whether or not this requires users to choose from a drop down I'm not sure (I personally would never include lookups of any kind in TABLE objects).

Yes I was referring to lookup when I said that the tables have a number of fields where the user is required to choose from drop down.
So does this mean that the use of lookups in tables create hidden indexes?

 

[xenou]

I'm not an expert on that topic but that was what was stated in the link I gave earlier:

One problem is that Access creates indexes due to relationships and lookup fields that aren't viewable on the main index property box but they are accessible via DAO collections.

If you do have lookups in your tables I would remove them and see if that helps.