Why is my query read-only?

Category: Queries Queries
Last Updated: 26 April 2010 26 April 2010

If you cannot edit the data in a query, then it is because Acess thinks it is not updatable.

For a query to be updatable, Access must be able to uniquely identify the record that will be changed. This is normally done by having the primary key. The recordset type must be updatable, You must also have write permission for the database,

To help you identify why your query is not updatable, some thigs to check are: