Operation must use an updateable query

[Guest]

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!

 

[Chris2]

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.