Does accessing a database query block the ability to edit a table?

Question

I created a query in Microsoft Access, as shown below:

SELECT Deliverables.ID, Deliverables.Title, Deliverables.Summary, 
Deliverables.Header_Code, Deliverables.Header_Code.Value, Deliverables.Sort_order, 
Deliverables.Pillar, Deliverables.Pillar.Value, Deliverables.Misc_ID
FROM Deliverables
WHERE (((Deliverables.Pillar.Value)="Link Building"));

But my problem is that this query blocks my fields, and I cannot make changes to the table using the query view.

Any suggestions? I am using Microsoft Access 2007

Answer 1

I am not very versed in multi-valued fields. However, I experimented a bit with it, and I think that the fields in your request may be editable if you can exclude Header_Code.Value and Pillar.Value from your list of output fields. Can this version work for you?

SELECT d.ID, d.Title, d.Summary, d.Header_Code, d.Sort_order, d.Pillar, d.Misc_ID
FROM Deliverables AS d
WHERE (((d.Pillar.Value)="Link Building"));