Quote Originally Posted by jonh View Post
If you're connecting to sql you can get this message due to problems with some datatypes I think.

Otherwise something or somebody is updating the same record.

It's pretty easy to replicate.

Create a query based on a table.
Open the table and query.
Change a value in the table. Don't close the table or move to a new record.
Change a value for the same record in the query and press f9 to save.
Switch back to the table and press f9 to save.

You could try changing the default record locking from no locks to edited record and see if/where it errors.
If it's a multi user system and someone is running update queries their queries will probably fail though.
Thanks - I should have seen it but I was looking in another direction. In this user only during sign on I had created some queries to add any new records in the system to a history file for easy lookup, then flagged those new records as having been added to the history. I believe that the flagging update was conflicting with other users that were doing input.

Looking at the forest instead of the trees. Thanks.