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.
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.
Provide each user with their own copy of the front end
Thanks CJ_London.
Once I provide each user with a copy of the front end what's the best way to handle record locking?
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
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.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
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