Lock Violations on Update Query

[scgoodman]

I have a linked table in access to sharepoint. I am trying to run an update query to update one field. It worked, until I had to rewrite the query. I didn't change anything as far as format, what could cause a lock violation issue? Any help is appreciated.