Results 1 to 1 of 1
  1. #1
    skaswani is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3

    Operation must use an updateable query

    Dear All,


    i am using MS Access 2007
    My Sql Query is :

    Code:
    UPDATE EmailSetup SET Email1 = (select  Email1  from BranchEmails where EmailSetup.BranchCode=BranchEmails.BranchCode), Email2 = (select DISTINCT Email2  from BranchEmails where EmailSetup.BranchCode=BranchEmails.BranchCode);
    and the error is :
    "Operation must use an updateable query"



    please advise


    query should be applied like this :

    Code:
    UPDATE EmailSetup as B INNER JOIN BranchEmails as A  ON B.BranchCode = A.BranchCode SET B.Email1 = [A].[Email1] ,B.Email2 = [A].[Email2] WHERE B.BranchCode = A.BranchCode
    Regards
    Last edited by skaswani; 12-24-2010 at 03:02 AM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Operation Must use an Updateable Query
    By Lady_Jane in forum Queries
    Replies: 2
    Last Post: 12-14-2010, 03:02 PM
  2. Perform an operation on multiple files.
    By newuser in forum Access
    Replies: 9
    Last Post: 11-18-2010, 11:21 AM
  3. Replies: 0
    Last Post: 03-27-2010, 01:25 PM
  4. Query decided it didn't want to be updateable anymore
    By tylerthompson in forum Queries
    Replies: 0
    Last Post: 07-23-2009, 09:43 AM
  5. Invalid Operation
    By ScottG in forum Forms
    Replies: 0
    Last Post: 11-14-2006, 02:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums