Firebird has a limit on the number of indexes that can be created on a
table, because the

On Fri, Dec 28, 2012 at 4:45 PM, shawnsieman <shawnsieman@...> wrote:

> I am a novice user of Access Database and Firebird's ODBC drivers. We
> recently updated Fishbowl Inventory software to the 2013.1 edition and now
> I get an error message- " there are too many indexes on the table 'TMP%#MAU@'
> how can this be fixed so I can refresh the tabels in Access Database?
>

Firebird has a limit on the number of indexes that can be created on a
table, because the index identifier is a byte. The system tables in
Firebird were designed in the early 1980's when every byte was precious.
So, the limit is either 255 or more likely 127. Drop some indexes. Any
table with more than 100 indexes suggests bad design.

Good luck,

Ann


[Non-text portions of this message have been removed]