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];
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
  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

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

P: 62

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];
Nov 1 '12 #2

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.