Help for update query

M

Min

Hi, I am trying to update a table using a query to set one column with all
the same data:

UPDATE Clients SET State = 'PA'

but the error message is "This operate must use a updateable query".

I am using MS Access 2000.

what's wrong?

Thanks!
Min
 
M

Min

This problem occurs when the query is run from the Query. If the query is
run from module, it's fine. I don't know what should be in an executable and
stand alone Query.
 
Top