"This record has been changed by another user ..."

[AdamFeerst]

When I try to change a field on a form, I get a message:
"This record has been changed by another user since you started editing it...."
This happens whether or I do it directly or via code (SQL update query).

The table's underlying record source is a linked SQL table.

What am I doing wrong?

 

[Ranman256]

Is the database split, or does everyone use the same db?
You must split the db. And everyone use their own copy of the Frontend. No sharing.

 

[sneuberg]

If there is any code that updates the record being edited you can get that messages.

 

[AdamFeerst]

Of course it's split. That was implied when I said linked table. No one else is in the table.

There is code. However, I am getting that same message when I try to edit directly in the table.

 

[AdamFeerst]

I am able to edit the data via a query in Access. However, I can't and get that same message when I try to run the query via VB, just like when I try to edit directly in the linked table, or from the form without code.