How to lock records

[star*]

I've set up a database for use by a team of approx 10 people. I've got problems with locking records so that only 1 user can edit a record at one time. This is happening in a form with a subform included... Can anyone help?

 

[IgorB]

There is no control over this problem as far as I know

 

[RuralGuy]

How do you have your default record locking set? Tools>Options>Advanced Tab. Are you getting errors?

 

[star*]

it's set to edited record. is this how it should be? People still appear to be able to access and make changes to the same record simultaneously.

 

[RuralGuy]

You have it set correctly and so far I see no evidence it is not working. What did you expect to happen?

 

[star*]

I was hoping that it would mean only 1 person could make changes to a record at a time,

 

[RuralGuy]

Not exactly. I just keyed in multiuser into the Access help Answer Wizard and it brought back several useful links on how it works. You may want to set up some tests to verify how the system works.