Access database query locks ability to edit table?

Posted by Sattvic on Stack Overflow See other posts from Stack Overflow or by Sattvic
Published on 2010-05-07T21:44:40Z Indexed on 2010/05/07 21:48 UTC
Read the original article Hit count: 171

Filed under:
|

I created a query in Microsoft Access like the one 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 locks my fields and I cannot make changes to the table using the query view.

Any suggestions? I am using Microsoft Access 2007

© Stack Overflow or respective owner

Related posts about access

Related posts about sql