Thanks for your help.


One question.

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?