Database Access issue

Question

Hi

I just wondering if you have time to help me with my Database Access issue. The problem is we have already a Database of complaints but when we try to open it there is a message attached here

for your information and assistance.

Answer 1

Hello Mereki,

Thanks for posting your question in the Microsoft Q&A forum.

It seems the database is corrupted. Attempt to restore it following the instructions provided in these links:

Microsoft Access Tips for Serious Users

Some Microsoft Access MDB Corruption Symptoms

To retrieve your data from a Corrupt Microsoft Access MDB

Microsoft Access Tips

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Answer 2

Hi Mereki Aneri •,

Welcome to Microsoft Q&A forum.

As I understand, your issue is 'Id' is not an index in this table - MS ACCESS.

Could you please tell if you are using any Azure Services or Databases of Azure?

Also, from the error and provided details, we can suggest you below links where the solutions provided could help:

It happens when Database is corrupted.

Refer below for more details:

https://stackoverflow.com/questions/35860331/id-is-not-an-index-in-this-table-ms-access

Corruption in an Access database resulting in the index error might occur when:

• The database is shared over a network in a multi-user environment; and, a copy of the database is accessed by multiple users simultaneously.
• The error message makes reference to the Visual Basic (VB) code. However, it is quite impossible to access the VB editor to check the real cause of the interruption.
• Different versions of the application (Access Database) are used over the network by different users. There are systems running Access 2007 and systems that are running Access 2010.

Thanks