This Recordset is not updateable (1 Viewer)

Hi All,

I have a query that uses 2 tables,

• tbl_EmployeeDetails
• tbl_Assets

The query is linked by employee ID.

The query returns everything in tbl_Assets and the employee name from tbl_EmployeeDetails.

It prompts the end-user to update the date of an asset but I keep getting "This Recordset is not updateable" and can't understand why.
Both tables have primary keys and the query is not grouped.

Any advice would be appreciated

See this list of possible reasons from Allen Browne.

Allen's article covers all likely causes for read only queries.
If that doesn't help you deduce the issue, please post your query SQL and a screenshot of the query design