| Subject | Re: [firebird-support] Does anyone know what the error too many indexes in table TMP%#MAU@ means |
|---|---|
| Author | Helen Borrie |
| Post date | 2012-12-29T18:45:22Z |
At 10:45 a.m. 29/12/2012, shawnsieman wrote:
Going by the fact that you have Firebird's ODBC drivers in your picture, I'm supposing you have some software package that exports data from a Firebird database to Fishbowl, which uses Microsoft's Access database as its back-end. The Firebird ODBC driver is a layer that enables that connection between the two totally different data management systems.
This group is about the Firebird relational database management system. Firebird itself doesn't create indexes unless you instruct it to, the exception being if you create or alter a table to add a primary, foreign or unique key. But your application software shouldn't be doing this kind of work...
If you're not a database developer yourself and you have no control over what your application software is doing, you need to contact the vendor of your software for a solution. It seems likely that the new version of Fishbowl is having some negative effects that they will want to know about and fix.
./heLen
>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?The error you are seeing comes from Access and is often related to Access's habit of creating duplicate indexes willy-nilly for its tables, on fairly unscientific bases, such as encountering a field name called "ID"!
Going by the fact that you have Firebird's ODBC drivers in your picture, I'm supposing you have some software package that exports data from a Firebird database to Fishbowl, which uses Microsoft's Access database as its back-end. The Firebird ODBC driver is a layer that enables that connection between the two totally different data management systems.
This group is about the Firebird relational database management system. Firebird itself doesn't create indexes unless you instruct it to, the exception being if you create or alter a table to add a primary, foreign or unique key. But your application software shouldn't be doing this kind of work...
If you're not a database developer yourself and you have no control over what your application software is doing, you need to contact the vendor of your software for a solution. It seems likely that the new version of Fishbowl is having some negative effects that they will want to know about and fix.
./heLen