Update Query to Sql view

[skizzly]

Hi all,

I have the following query::


UPDATE [dbo_vwAttendance Live] INNER JOIN offRolll ON ([dbo_vwAttendance Live].PER_DOB = offRoll.DoB) AND ([dbo_vwAttendance Live].PER_SNAME = offRolll .Surname) AND ([dbo_vwAttendance Live].PUP_UPN_DFEE = offRolll.UPN) SET [dbo_vwAttendance Live].PAT_TO_DATE = [LeavingDate]
WHERE ((([dbo_vwAttendance Live].PAT_FROM_DATE)=[EntryDate]) AND ((offRolll .LeavingDate)>[PAT_FROM_DATE]));

dbo_vwAttendance Live is a view, on Sql Server 2008, that is built from multiple tables.

My intention is to update the PAT_FROM_DATE for multiple rows in sql to the value in a local table, with a value in the EntryDate field.

However I am getting the following message when I run the query in Access 2003:

"Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values."

Any help would be appreciated...........