Update

[mayu03]

i am trying to run update query.
I am getting this error(even the query is update query any idea why?)"Operation must use an updateable query"

 

[Golom]

The message means (usually) that Access can't identify a unique record to update. Post your code and we may be able to suggest some alternatives.

 

[koresnordic]

I have had this where I am using (not updating) a table that is linked to an external source and Access doesn't know the key fields. I have only been able to resolve this by deleting the original table, creating the link again, but ensuring that I specify key fields.



Graham