Simple UPDATE query not running

[Sandra Walsh]

I am getting the error "Operation must use an updateable query" when I run the following Query:

UPDATE q_ADMIN_MergedContactIDs 
INNER JOIN t_RelatedContacts ON q_ADMIN_MergedContactIDs.Old_ID = t_RelatedContacts.Contact_ID 
SET t_RelatedContacts.Contact_ID = [q_ADMIN_MergedContactIDs].[New_ID];
 

t_RelatedContacts only has 4 number fields:
RelCon_ID - AutoNumber
Contact_ID - Number - Long Integer
Activity_ID - Number - Long Integer
Referral_ID - Number - Long Integer

This is the code for q_ADMIN_MergedContactIDs. dbo_INT_AUX_MRG_DEL_HISTORY is an ODBC-linked table.

DUP_LIST_ID - Number - Long Integer
GOOD_LIST_ID - Number - Long Integer

SELECT dbo_INT_AUX_MRG_DEL_HISTORY.DIR_ID, dbo_INT_AUX_MRG_DEL_HISTORY.DUP_LIST_ID AS Old_ID, dbo_INT_AUX_MRG_DEL_HISTORY.GOOD_LIST_ID AS New_ID, q_MasterRelatedContacts.Display_NM
FROM dbo_INT_AUX_MRG_DEL_HISTORY INNER JOIN q_MasterRelatedContacts ON dbo_INT_AUX_MRG_DEL_HISTORY.DUP_LIST_ID = q_MasterRelatedContacts.Contact_ID
WHERE (((dbo_INT_AUX_MRG_DEL_HISTORY.DIR_ID)=-2));

Any insight greatly appreciated.
Thanks,
Sandra

[Sandra Walsh]

UPDATE:

The Update query runs when I do a MAKE TABLE on the second query and use the TEMP table instead of q_ADMIN_MergedContactIDs.

UPDATE Temp_UpdatedContactIDs INNER JOIN t_RelatedContacts ON Temp_UpdatedContactIDs.Old_ID = t_RelatedContacts.Contact_ID SET t_RelatedContacts.Contact_ID = [Temp_UpdatedContactIDs].[New_ID];
 

[NeoPa]

Reasons for a Query to be Non-Updatable may prove helpful Sandra.