If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Operation must use an updateable query
I am trying to create an update query using two tables. The first table is
in the actual database I'm working on and the other is a linked table from another database. When I set the query up and run it I get an error message "Operation must use an updateable query". If I import the file I'm linking to rather than update, it works. Help! |
#2
|
|||
|
|||
"NZC" wrote in message ... I am trying to create an update query using two tables. The first table is in the actual database I'm working on and the other is a linked table from another database. When I set the query up and run it I get an error message "Operation must use an updateable query". If I import the file I'm linking to rather than update, it works. Help! NZC, Hold onto your hat . . . MS Access does that deliberately. If there is any form of aggregation involved, or a lack of all tables JOINed on their Primary Keys, you can get this error. Sincerely, Chris O. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Not updateable query | John | Running & Setting Up Queries | 2 | November 23rd, 2004 02:23 PM |
"Operation must use an Updateable Query." - How do I get round this? | John Ortt | Running & Setting Up Queries | 1 | November 10th, 2004 12:04 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Full Outer Join not Union to produce an updateable query | Lori Zorr | Running & Setting Up Queries | 2 | August 12th, 2004 07:48 PM |
Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |