MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Error Ć¢€œAOIndex' is not an index in this tableĆ¢€ - Get it Fixed with An Utility Or A Professional Software

Published on 22 October 14
743
4
1

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
The Access database can also be recovered easily with the help of a professional software. The software can be used to fully repair Access mdb and the accdb database files, on account of any type of database corruption which are due to hardware problems, conflicting software or inconsistency in the database design. A preview of the database components is available. The password protected forms and modules can be retrieved with this tool.










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
The Access database can also be recovered easily with the help of a professional software. The software can be used to fully repair Access mdb and the accdb database files, on account of any type of database corruption which are due to hardware problems, conflicting software or inconsistency in the database design. A preview of the database components is available. The password protected forms and modules can be retrieved with this tool.

Related Posts:
View Comments (4)
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
  1. 13 March 15
    0

    Great post and excellent explanation. With this is not necessary a recovery software and in any case I prefer to use AccessFIX

  2. 28 February 15
    0

    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.

  3. 21 January 15
    0

    Congratuation Tom!!!

    You have solved your problem.

    Happy to help!

  4. 22 December 14
    1

    Hi Mark,

    Thanks a lot for this method that fixed my problem. A lifesaver solution for all Access DBA!!!

You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top