Does anyone know if the limit of 32 indexes per table within Access will be
changed in the future, or is this a key feature designed to have you upgrade
to SQL Server. (I know that you should not have 32 indexes on a table, but
indexes are automatically generated when you create relationships between
tables - we have a very complex data model for oil industry engineering).
A simple work around is to have 1-to-1 relationships with an intermediate
table. Or application is a commercial application that runs against most of
the popular ODBC RDBMS's. Access is the only database system that imposes
the index limit.
Your response is greatly appreciated.