Error -œAOIndex' is not an index in this table- - Get it Fixed with An Utility Or A Professional Software
The error ‘AOIndex is not an index in this table’ is displayed and the user is unable to get into the Access database. The reason for the error condition is database corruption. "MsysAccessObjects" is a hidden file system table in the Access database that displays the corruption. The records of the table have NULL in both the ID and the data fields. There is no index for the table. A good database always has an index called the “AOIndexâ€.
Solution
The best solution for Access database corruption lies in the regular backup of the database and also not running a database in the network, in the unsplit form. This database corruption is repairable and is done with the Access database repair Utility. Also, a professional software is available for the recovery.
The repair of the corruption is done with the help of removal of all the bad records from MsysAccessObjects as well as the reconstruction of the index with the DAO (Data Access Objects).
The code is needed to be run from another database; the corrupt database cannot be used for running the code.
The Utility database "FixBadAOIndex.zip" can be downloaded and opened by the holding down of the Shift key. The procedure "FixBadAOIndex" in module "basFixAOIndex" has to be inspected.
Steps in Fixing Access DB by Using A Utility
The steps in the procedure for fixing the above error condition, with the Utility are:
- Two backups of the Access database are made. One for the backup purpose, another in a situation, when the database gets corrupt, as a result of using the Utility.
- The Utility database is downloaded and the .mdb file is extracted from the zip archive
- Sometimes, as demanded by the version of the Access database, a trusted location is used for the storage of the code-bearing database. The Utility database is kept in the trusted folder, used for this purpose
- The FixBadAOIndex.mdb file is either opened or double clicked. At this stage, if the code in the database is disabled, then it needs to be enabled
- A file-browse dialog box appears. We need to select the corrupt database to be repaired. One of the corrupt copies of the database has to be selected by double-clicking or opened
- A confirmation of a backup copy of the Access database is taken. If the answer given is no, then the Utility simply quits, without even touching the database. If the answer provided is 'Yes', then the Utility, the database password is asked for. The password is entered and “OK†is clicked, otherwise “Cancel†is clicked
- The Repair process of the Utility starts now
- The Utility will interact by telling whether, the repair process is successful or not. The success does not mean that the database is fully repaired. There is likelihood of other possible reasons for corruption. However, the repaired database can be opened
- After the repair process is over, a blank new database is created for importing all the objects from the repaired database into it
- We start using the new database, so as to eradicate any other hidden form of corruption
Great post and excellent explanation. With this is not necessary a recovery software and in any case I prefer to use AccessFIX
Interesting. i have experienced such problem time ago and i have tried to run this software, but it did not help in issue. But another one software solved my problem, Recovery Toolbox for Access https://access.recoverytoolbox.com/
maybe it will help someone else.
Congratuation Tom!!!
You have solved your problem.
Happy to help!
Hi Mark,
Thanks a lot for this method that fixed my problem. A lifesaver solution for all Access DBA!!!