Update Qry - Updatable (1 Viewer)

Gismo

Registered User.
Local time
Today, 17:36
Joined
Jun 12, 2017
Messages
1,298
Hi,

I have hundreds of update queries but this one seems to boggle my brain
i get an "operation must be an updatable query" error

I have a query that filters the data I need to update, then linked to the Table i am updating
there is no duplicate fields in the 2 tables

please could you assist, not sure what i am missing here

1608034789839.png


1608034756762.png
 

Minty

AWF VIP
Local time
Today, 15:36
Joined
Jul 26, 2013
Messages
10,355
The simple route with these is to change it to a select query and see if you can edit it.

If you can then today Access doesn't like you.
Try converting the joins to a sub query and make the criteria an IN(Your Sub query)
 

Gismo

Registered User.
Local time
Today, 17:36
Joined
Jun 12, 2017
Messages
1,298
The simple route with these is to change it to a select query and see if you can edit it.

If you can then today Access doesn't like you.
Try converting the joins to a sub query and make the criteria an IN(Your Sub query)
It is updateable when select query
the one object is a query and the other is the table
shall i select a query as well for the table?
 

Minty

AWF VIP
Local time
Today, 15:36
Joined
Jul 26, 2013
Messages
10,355
You probably need to actually move to what Access thinks is two tables, even if one is temporary.
 

Users who are viewing this thread

Top Bottom