Make ODBC-Linked Tables Editable in Microsoft Access Queries
Question details
The user needs to edit an ODBC-linked table when it is combined with another table in an Access query.

- 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.
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.
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.
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.
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.
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.
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.

Edit related tables with a main form and subform
Use separate forms when the joined query remains read-only or when users need to edit related records reliably.
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.

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.




