Operation must use an updateable query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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