Updating Query

[Guest]

Access is refusing to update a query, stating that the Jet engine has halted
the process because another user is updating the information. This is a
stand-alone database with no shared user or third-party access, so this is
impossible. Any thoughts?

 

[John Spencer]

I would guess that there is another user. The other user is some other
process in Access that is also updating information on the table.

Do you have the table open in datasheet view and are you updating the table
there? Or perhaps a query? How about some other code that has opened the
table for editing, but not released the table?