At my company we developed an aplication that control inventory.

That aplication is now installed as a single user, but my boss want to put it as a multiuser enviroment under SQL Server ( The tables are allready in SQL SeRVER).

For the master tables, everything is fine...cause with i lock the record and noone have access to it until it became unlock.

But for the inventory process, the thing becames harder, and my boss want to make some research to implement the multiuser specification on the server-side, i mean, on the sqlserver, not in frontend(visualbasic).

How can i do it?