"Operation must use an updateable query" On UPDATE Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all,

I'm working on Access 2000, linking to a SQL Server 2000 table. When I try
to run INSERT commands through Access, everything works OK. But when I try to
make an UPDATE, it bombs out with an "Operation must use an updateable query"
error.

I can't think of a reason why one would work and the other wouldn't. I'm not
an expert at SQL Server, but when I go into Enterprise Manager and view
permissions for the table in question, it looks to be set up the same as a
different table that I CAN run updates against. I'm confused.
 
It could be that your update query has more then one table, try and change
the properties of your query.
in the properties change the UniqueRecords Property to true, and try
 

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

Operation must use an updateable query 13
Must use an Updateable Query - Issue 0
Update Query - Operation must use an updateable query 3
Update query error: "Operation must use an updateable query" 1
Operation must be an updatable query 8
Update table with values from another table 2
Error: Operation must use an updatable query 2
Update query issue 0

Back
Top