Help for update query

  • Thread starter Thread starter Min
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query error: "Operation must use an updateable query" 8
Update a table from a query 7
Operation must us an updateable query 1
i am getting an error 'operation must be an updateable query in ac 11
Update query won't work 2
Query works on dev db, gets a Run-time error '3073': Operation mustuse an updateable query on Pre-pr 1
Update query error: "Operation must use an updateable query." 3
Recordset not Updatable. 1

Back
Top