Hi all. I have one problem. Recently I was working with my access database and added a lot of info into the document. I `ve got to hand over month report soon I`m working all day and night long. Don`t know why but my PC got BSOD. After that I tried to open my document and see error “Operation failed - too many indexes - reduce the number and try again” What should I do? How can I fix this? Is it because of the size of the document? It`s about 10 gb. My Office 2010 worked just well until it happened. So, any suggestions?

This message can occur when one table in the Microsoft Access MDB is corrupted and you are importing data. However this message could be quite legitimate as well if working in the relationships window.

The index definitions are corrupted. The semi-failure occurs because Access first imports the table definition and data, and then tries to apply the indexes. Since the index definitions are corrupted, it errors out. Your table's data is of course fine.

What you want to do is to create a copy of the table, but without any data. Remove all indexes. Run an append query and move the data from the problem table to the new table (they can be in the same file). Then recreate the indexes (not by copying and pasting!). Finally, move the new table to a new file. That should solve your problem