Query not updateable?

[Kerropiday]

Hi,

What does it mean when a query is not updateable? I am not
talking about doing an "update query" but when I run a
regular "select query" and I can not update the values of
the select query - what are the most likely causes of this
problem? because I know in general you should be able to
update the data in a select query.

My problem is a select query that involves 5 tables, when
I remove one of the tables, the query suddenly
become "updateable" does that mean I have relationship
problems?

Thanks in advance

 

[Lynn Trapp]

Search Access Help for "updateable query". It will give you the
circumstances under which a query might not be updatable.