Database Access issue

Mereki Aneri 0 Reputation points
2024-04-10T03:26:01.8733333+00:00

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 Screenshot 2024-04-10 151841

for your information and assistance.

Azure SQL Database
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
393 questions
{count} votes

2 answers

Sort by: Most helpful
  1. hossein jalilian 7,280 Reputation points
    2024-04-10T06:16:37.26+00:00

    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

    0 comments No comments

  2. ShaktiSingh-MSFT 15,311 Reputation points
    2024-04-10T09:16:25.4933333+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.