Linked SQL tables marked as unupdateable in Access

[dpelizzari]

I am trying to create a form in Access 2007 based on two linked SQL 2005 tables. the form works fine, but when I attempt to update a field, I get the infamous message "this recordset is not updatable". Both tables have a unique ID, and show up in Access this way.

My SQL code:
SELECT SITELIST.Site, SITELIST.BU, SITELIST.Deployer, dbo_isd_lease.Ticket_num, dbo_isd_lease.smsLastLoggedOnUserName, dbo_isd_lease.chkAddedtoOutlook
FROM SITELIST INNER JOIN dbo_isd_lease ON (SITELIST.Site = dbo_isd_lease.rSite) AND (SITELIST.BU = dbo_isd_lease.BU)
WHERE (((dbo_isd_lease.Ticket_num) Is Not Null));

I want to update the chkAddedtoOutlook box (bit, set to 0) after a function is performed successfully.

Do I need to break the join and write to one table specifically? How?
Any assistance would be greatly appreciated, I have several examples of trying to do this without success, one solution should fix them all!

 

[namliam]

2 things required:
1) The user connected needs to be able to update the table (security)
2) A primary key defined in the table(s) AND used in the join

 

[dpelizzari]

I assume what you mean is to actually make a join between the two primary keys? The primary keys in this instance are record ID's, and based on data input, the keys won't match. Are you suggesting a full outer join then?