How to lock or even highlight a cell in an Access when the database is split and many users are on?

[Yodo]

I need to arrange a concurrent work for several users on one db. I tried splitting and I think that it works fine for me. But it gives me a message that while a cell has been selected by me, another user has already made changes, so I can either put mine and discard his or copy his to clipboard. I want to prevent this conflicts by simply locking the cells or highlight them as it done in google sheets. Are there any ways to do that?

[ranman256]

Are the odds of 2 of you changing the exact same record that close?
you could use a list ,then when user picks that item to edit, check a [inUse] field.
if empty ,fill it with the userId,then open the form to edit.
when done editing,it empties the InUse field.

if filled,notify the user they can't edit it yet.

[HiTechCoach]

If the write conflict is happing often I usually find that the underlying cause is a table design issue. The data is not properly normalized to handle multiple users.

I see this a lot where there is a single table with lots of fields. Like a spreadsheet. Multiple users are editing different field(s) on the same record at the same time.

Will you please share some more details about the design of your table(s).