Looking for the Best way to handle record locking

[brian11670]

I am creating a MS Access frontend with sql server backend and I am looking for the best way to handle when multiple users will be access the same worklist.

[CJ_London]

Provide each user with their own copy of the front end

[brian11670]

Thanks CJ_London.
Once I provide each user with a copy of the front end what's the best way to handle record locking?

[CJ_London]

should happen automatically with the standard settings, using bound forms with DAO connecting via ODBC. With ADO you need to specify - but that depends on what you are doing

[Minty]

To back up what CJ is saying, SQL server will handle the locking more than adequately with the standard settings unless you are doing something either Daft or very Non-standard.

[NoellaG]

If you need other than standard locking : use passthrough queries. There you can add hints like with (UPDLOCK) or with (NOLOCK) or you can set the isolation level in the statement.
https://learn.microsoft.com/en-us/sq...l-server-ver16