Others

Make ODBC-Linked Tables Editable in Microsoft Access Queries

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

The user needs to edit an ODBC-linked table when it is combined with another table in an Access query.

Make ODBC-Linked Tables Editable in Microsoft Access Queries
Product
Microsoft Access
Device & OS
not provided
Scenario
An Access select query combines an ODBC-linked table with another linked or local table.
Observed behavior
The linked table is editable on its own, but its columns become read-only after another table is added to the query.
Before you start

Open the linked table by itself and confirm that you can edit a record. Identify its unique key and any fields used to join it to the other table.

Solution 1Recommended

Check the linked table's unique key and query joins

Use this approach when a linked table becomes read-only only after another table is added to the query.

1
Inspect the unique key

Open the source database's table design or ask its administrator to confirm that the linked table has a primary key or unique index. If the key contains multiple columns, identify every column in it.

2
Verify the linked table

In Access, open the linked table from the Navigation Pane and confirm that you can edit a record. If Access does not recognize a unique identifier, relink the table through External Data > New Data Source > From Other Sources > ODBC Database and select the complete unique key when prompted.

3
Review the joins

Open the query in Design View and inspect the join lines between the tables. Where the relationship uses a composite key, join the corresponding fields for the complete key rather than only one field.

4
Check the query structure

In Design View, review the query for totals, DISTINCT, or other features that can prevent updates. Remove them if they are not needed, then switch to Datasheet View and test editing the linked table's fields.

Check the linked table's unique key and query joins
A valid key may not be enough: Some multi-table queries remain non-updateable because of their joins or structure. Source database permissions and table relationships can also affect editing.
Free Microsoft Office alternative

Work with Office documents and data in WPS Office

WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Office format compatibility make moving existing files straightforward. It does not fix Access query updateability or replace Access database forms.

Review and organize tabular data in WPS Spreadsheets.Open and edit Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX files.Use a familiar interface for common Office tasks.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my linked table editable alone but read-only in a query?

Adding another table can make a query non-updateable because of its joins, unique keys, or query structure. Open the query in Design View and inspect the join fields and any totals or DISTINCT settings.

Do I need to join every field in a composite key?

When the relationship uses a composite key, join the corresponding fields that make up the complete key. Joining only one field may fail to identify the intended related record.

How can I identify records in an ODBC-linked table?

Confirm that the source table has a primary key or unique index. If Access prompts for a unique record identifier when you link the table, select all columns that make up the unique key.

Can a form and subform make any joined query editable?

No. A form and subform can use separate record sources instead of one joined query, but each record source must still be updateable and the user must have permission to edit its underlying data.