'Id' is not an index in this table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Aftab Ahmad
    New Member
    • Jan 2015
    • 49
    #1

    'Id' is not an index in this table

    Hello developers!
    I was working on project since 1 month and it is going to finish in 2 to 3 days. My MS Access Database is saved in my flash drive on which I was working. Suddenly, the flash drive is disconnected without any reason and my opened Database is getting error as "'Id' is not an index in this table." I have more than 69 tables in this Database. How can I fix this issue as it is not indicate the table name which is not indexed.
    Tags: None
    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32636
      #2
      Hi Aftab.

      With almost no helpful information in your post there's little we can say.

      Obviously, if you were working on your project without any sort of backups then saying you need to keep backups is no help this time, but make sure you learn from this never to work on anything of any importance without robust backups.

      Assuming you have none though, I can only suggest you try - ON A COPY OF YOUR DATABASE & not the original - deleting tables until what you have left no longer gives you the error. At that point the most recently deleted table is likely to be the one that needs attention.

      Clearly not as easy as simply going back to the last safe backup, so if that option is available then definitely take it.

        Comment

        • Aftab Ahmad
          New Member
          • Jan 2015
          • 49
          #3
          Hi NeoPa. You replied me as usual. Thanks.
          I tried the same but not fruitful. One thing more I noticed that my visual basic is also not opening. I am thiking that this problem maybe due to corruption of system tables like MSysObjects etc. What's your opinion? I tried to import all objects by creating a new one but in vain. I also tried some third party softwares like Stellar. It recover my tables and queries but other objects e.g., Reports, Module and especially Forms which are most important for me are not recovered. Can I share my database with you in personal please?

            Comment

            • NeoPa
              Recognized Expert Moderator MVP
              • Oct 2006
              • 32636
              #4
              Hi Aftab.

              "I tried the same but not fruitful."
              That is not a helpful response to what I've said already. You've dimissed everything I've said with a short sentence that tells me nothing.

              You must do more if you want anyone to spend their time trying to help. What have you tried exactly? What were the results, exactly?

              I'm afraid that my taking your database & sorting it all for you would simply be a way for you to avoid doing the work you need to do to :
              1. Fix this problem.
              2. Ensure that similar problems don't happen to you again.

              For everything I said about backups & how to proceed with what you actually have to ensure that you can find the problem table, all you've said is what's above in quotes.

              I understand that English is not your first language, but I fail to see why that would cause the absence of any meaningful response to my suggestions.

                Comment

                • isladogs
                  Recognized Expert Moderator Contributor
                  • Jul 2007
                  • 479
                  #5
                  ID is not an index in this table is Access error 3800 and indicates likely corruption, almost certainly in one of your system tables.
                  Did you try importing all objects (except system tables) into a new blank database?

                    Comment

                    Previous template Next
                    Working...