Operation must use an updateable query

N

NZC

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!
 
C

Chris2

NZC said:
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!
Click to expand...

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.
 
Top