Fix Microsoft Access Error: Operation Must Use an Updateable Query
Question details
The user needs to resolve an error preventing an update query from copying values from an inventory query into a target table.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to run an update query to copy a value, such as Weight, from an inventory query into a target database table.
- Observed behavior
- Microsoft Access blocks the update operation and displays the prompt: "Operation must use an updateable query."
Ensure that your Access database (.accdb) is not located in a read-only folder and that you have full Windows read/write permissions for the directory.
Create a Unique Join in Query Design
Resolve the update error by establishing a direct and editable join between the inventory query and the target table using matching fields.
This error commonly occurs when Access cannot determine which specific records to update because the relationship between the source query and target table is ambiguous or missing. Creating a direct, unique join resolves this data relationship.
In Microsoft Access, locate your failing update query in the navigation pane, right-click it, and select Design View.
Ensure that both your inventory query and the target table are added and visible in the upper section of the Query Design window.
Click and hold the ProductID field in the inventory query, drag it directly over to the corresponding ProductID field in the target table, and release your mouse to create a join.
Check the query grid at the bottom to confirm that your 'Update To' row targets the correct Weight field and that the newly created join supports data edits.

Need a Lightweight Alternative for Daily Office Tasks?
While Microsoft Access is built for complex database management, WPS Office provides a powerful, free alternative for your daily word processing, spreadsheet, and presentation needs. It is fully compatible with Microsoft Office formats and extremely resource-friendly.
- 1. Download the Installer: Visit the official WPS Office website and download the free setup file.
- 2. Install WPS Office: Run the installer and follow the standard on-screen instructions to complete the setup.
- 3. Open Existing Documents: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office files without formatting loss.

Frequently Asked Questions
Why does Microsoft Access say my query is not updateable?
A query becomes non-updateable if it includes aggregate functions (like SUM or COUNT), lacks a primary key, or uses non-unique joins between tables, which prevents Access from tracing data back to a specific record.
Can I update a table using a Totals or Group By query?
No, Access does not allow direct updates from queries that group data or calculate totals. You must write the aggregated results to a temporary table first, and then run an update query from that temporary table.
Could Windows folder permissions cause the updateable query error?
Yes. If your Access database file (.accdb) is located in a read-only folder, or on a network drive where you lack write permissions, Access cannot update the data and will throw this error.




