I am creating a multi-user application using SQL Server as the data repository with Access 2003 as the front-end. Is there any way I can prevent 2 users editing the same record at the same time. I have tried using sp_indexoption in SQL Server but it still allows access. I want to be able to prevent a second user modifiying a record once it is being edited. Is this possible? Thanks in advance Paul.