Share via

Table is read only error

Anonymous
2014-04-06T21:50:20+00:00

I have a form that creates a record in a several tables based on information the form reads from an imprted table.

All of this has been working properly, but now, when one o fthe tables is supposed to be filled in, I get an error message saying the table is read only.

I have not been able to figure out what causes it. If I open the table and add the record manually, it is accepted.

????

Microsoft 365 and Office | Access | For home | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2014-04-06T23:06:54+00:00

    First I would repair & compact the database.

    Then focus on the query itself. Is it still what it used to be? Maybe easiest to rewrite?

    Some queries are always readonly, for example all totals queries and all union queries.

    In some cases it helps to set the query's Unique Records property to Yes.

    Was this answer helpful?

    0 comments