Others

Fix Microsoft Access Error: Operation Must Use an Updateable Query

Jason MillerJason Miller Oct 23, 2026 872 views

Question details

The user needs to resolve an error preventing an update query from copying values from an inventory query into a target table.

How to Fix "Operation Must Use an Updateable Query" in Access
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."
Before you start

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.

Solution 1Recommended

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.

1
Open Query Design

In Microsoft Access, locate your failing update query in the navigation pane, right-click it, and select Design View.

2
Verify Tables and Queries

Ensure that both your inventory query and the target table are added and visible in the upper section of the Query Design window.

3
Link the ProductID Fields

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.

4
Validate the Update Target

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.

Create a Unique Join in Query Design
Join Verification: A physical line will appear connecting the two ProductID fields, ensuring Access knows exactly how the records correlate.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free setup file.
  2. 2. Install WPS Office: Run the installer and follow the standard on-screen instructions to complete the setup.
  3. 3. Open Existing Documents: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office files without formatting loss.
Free and lightweight complete office suiteFully compatible with Microsoft Word, Excel, and PowerPoint (.docx, .xlsx, .pptx)Familiar and intuitive user interfaceSeamless migration with no learning curve
microsoft office alternative - wps office

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.