Change data in a query, locked?

R

Rwh5757

When trying to change data in a select query (Access 2002), it will not let
me and sounds a beep. I was able to change data in it previously, but not
now. In Options, I changed it to Exclusive, and no locks. That is how it is
now, but no updates can be done. I am on a network, but am using a local
version of the file. Any help you can give would be appreciated. Thank you.

Richard
 
J

Jerry Whittle

Does the query include more than one table? If so it's really easy to get and
unupdateable query where you can't add, delete, or edit records. When you
heard the beep, there may be a warning message at the lower left of the
Access window.
 
R

Rwh5757

Jerry,

The query only has one table showing in the Design view. Also, there is no
warning message showing at the lower left.

Richard
 
R

Rwh5757

Jerry,

While looking at the help file, it says that you can't update a query that
calculates a field based on other values, which this query has. The field
I'm trying to change is a flag field (Yes/No) which doesn't have anything to
do with the calculated fields, or their source data. Would the Yes/No field
still be unupdatable?

Richard
 
J

Jerry Whittle

Aha! If any part of the query has a calculated field, that will stop the
query from being updateable. The Yes/No field would not be updateable even if
it isn't part of the calculation.
 
J

John Spencer

I think that having a calculated field making a query not updatable is not
quite true as stated. You can have calculated fields in a query and the
query can be updated. The calculated field will not be updatable.

If you have a subquery in the select clause that will make the query not
updatable (at least in my tests).

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top