Can anyone think of a reason why my records won't lock, even though the form record locks property is set to Edited Record?
A form is bound to a linked SQL Server table, not a view or query, and when I edit the same record there are no conflicts.
When the same field is being edited at the same time, the first application to save will write to the table and save the change.
When the second application eventually saves, that overwrites the first apps change. BUT...if the first app goes back to the re-edited record (that should now be different), it hasn't updated and is how it was changed the first time - not what is stored in the sql server table.
This happens even with No Locks set.
A form is bound to a linked SQL Server table, not a view or query, and when I edit the same record there are no conflicts.
When the same field is being edited at the same time, the first application to save will write to the table and save the change.
When the second application eventually saves, that overwrites the first apps change. BUT...if the first app goes back to the re-edited record (that should now be different), it hasn't updated and is how it was changed the first time - not what is stored in the sql server table.
This happens even with No Locks set.
Last edited:
