Unmatched Query Not Updatable

[Rainbowhawk]

Having an issue with an unmatched query,

The first part retrieves a list of people who have passed a course and compares it against another query to check that the course has not expired, this is then presented to the end users, however when the query is run it reports

This recordset is not updatable

When the users try to edit fields, I need to either

a) Find a quick easy fix
b) Explain in English that a Manager can understand why its not working

I am leaning towards B but struggling to explain it

Query with issue

SELECT EmployeeMHSkill.WSKEID, EmployeeMHSkill.[Staff ID], EmployeeMHSkill.MHSkill, EmployeeMHSkill.DateCompleted, EmployeeMHSkill.[Trained By], ZMHExpired.WSKEID AS ZWSKEID
FROM EmployeeMHSkill LEFT JOIN ZMHExpired ON EmployeeMHSkill.WSKEID = ZMHExpired.WSKEID
WHERE (((ZMHExpired.WSKEID) Is Null))
ORDER BY EmployeeMHSkill.MHSkill
WITH OWNERACCESS OPTION;

Feed Query

SELECT EmployeeMHSkill.[Staff ID], EmployeeMHSkill.MHSkill, EmployeeMHSkill.DateCompleted, EmployeeMHSkill.ReviewDate, EmployeeMHSkill.[Trained By], DateDiff("m",[ReviewDate],Now()) AS [Months Old], EmployeeMHSkill.WSKEID, EmployeeMHSkill.Review
FROM EmployeeMHSkill INNER JOIN ZMHSkillListing ON EmployeeMHSkill.MHSkill = ZMHSkillListing.MHSkill
WHERE (((EmployeeMHSkill.[Staff ID])=[Forms]![E Admin]![Staff Number]) AND ((DateDiff("m",[ReviewDate],Now()))>=-1) AND ((ZMHSkillListing.Discontinued)<>-1))
ORDER BY EmployeeMHSkill.MHSkill;

Note: Using Access 97 (I know its now an antique but its all they will let us have)

 

[branston]

Only had a very quick look at your problem, but I have come up with this quite a lot - it seems to happen when you are linking tables that do not have a 1 to 1 relationship. In other words, Access can't update the field as there is more than one record which the change could apply to.
Hope that helps.

 

[boblarson]

Read this and see if any of it helps.

 

[Rainbowhawk]

Cheers Guys