>>If you want to grant 10 licenses, create a table with 10 records. Whenever a >>user logs in, he grabs the first available record and locks it.
>>When 10 records are locked, no more users can grab a license and the program >>bounces them.
>>If any workstation crashes, its locked record is released.
>>This is the simplest way I've seen for implementing what you need, but I'm >>sure that someone can poke holes at it and/or come up with something more >>interesting.
>>alex

Hi Alex, pardon me for jumping in :) , but I have a similar problem. We use the record locking in our current version, but the new version uses views and at a later time will allow SQL server as the backend. I am unable to fit in the locking scheme in this scenario... can it still be done??

Thanks for you time!