I have a multi client application.
>Each one of my clients has their own data folder, containing a database container, client.dbc, with their own set of tables.
>The client's folder name reflects who they are. The folder name contains their account number.
>
>Example:
>
>c:\app\data contains all my system data in appdata.dbc.
>
>c:\app\data\data0001 contains all the data for cleint 0001 in client.dbc.
>c:\app\data\data0002 contains all the data for cleint 0002 in client.dbc.
>c:\app\data\data0003 contains all the data for cleint 0003 in client.dbc.
>
>When a user opens a client account,
>I want to open client.dbc with exclusive access so no one else can open the client account.
>
>What is the best way to do this?
>What technique do you recommend?