Share via

Linked SQL database Table to MS access front end is opening only in readonly mode

Anonymous
2024-10-31T09:34:02+00:00

I recently migrated an Access database to SQL Server using the MS SQL Migration Assistant for Access. The migration process completed successfully, and the tables were automatically linked.

However, I am encountering an issue where I am unable to edit entries in some of the linked tables. Additionally, when I run VBA code to edit the entries, I receive an error message stating that the "database is in readonly mode."

the SQL user has sufficent read/write rights.

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-11-07T14:07:45+00:00

    Now that the tables in SQL Server do have Primary keys, you can try relinking the tables in Access so that Access can recognize them.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-11-07T14:02:58+00:00

    I added primary key to all tables still facing the same issue.

    Was this answer helpful?

    0 comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-10-31T14:12:56+00:00

    Great, but the more important factor is that each table has a Primary Key which Access recognizes in the linked table.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-10-31T13:03:34+00:00

    Yes there is column name SSMA Timestamp

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-10-31T11:59:43+00:00

    Does every table have a PK? Normally we add a timestamp or rowversion column to every table

    Was this answer helpful?

    0 comments