Please see attached a front end and back end database. There is only one table and one form.
On the form there is only one field - which updates a memo field in the table in the back end.
When two users have the form open (displaying the one and only record, 356 chars counted in Word) if you add one more characters to the record it cannot be saved
If you delete a character, then save, then you can then replace it.
For example open the front end on two pc's, open the form and try to add the letter E to the very end of the form.
You get a message saying the record is locked on the other machine.
If you have the form open exclusively then you can save OK
The original form was more complicated but I have cut this down to show that the other stuff I had on the form was not causing the problem.
Do I have the Access Options for refresh and locking set correctly?
I am at a loss to explain this.
My customer discovered the problem on his network - a different setup completely to mine.