By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Simple UPDATE query not running

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

Expand|Select|Wrap|Line Numbers
  1. UPDATE q_ADMIN_MergedContactIDs 
  2. INNER JOIN t_RelatedContacts ON q_ADMIN_MergedContactIDs.Old_ID = t_RelatedContacts.Contact_ID 
  3. SET t_RelatedContacts.Contact_ID = [q_ADMIN_MergedContactIDs].[New_ID];
  4.  
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

Expand|Select|Wrap|Line Numbers
  1. 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
  2. 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
  3. WHERE (((dbo_INT_AUX_MRG_DEL_HISTORY.DIR_ID)=-2));

Any insight greatly appreciated.
Thanks,
Sandra
Nov 1 '12 #1
Share this Question
Share on Google+
2 Replies


P: 62
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.

Expand|Select|Wrap|Line Numbers
  1. 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];
  2.  
Nov 1 '12 #2

NeoPa
Expert Mod 15k+
P: 31,276
Reasons for a Query to be Non-Updatable may prove helpful Sandra.
Nov 2 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.