I am working on a user license routine that adds a record to a table and locks the record when they are logged into the system. I can then use this data to pull a list of users or count how many people are using the software and not let them exceed their number of purchased licenses. I can also see who is in the system so if we need to make changes and someone is logged in we can go straight to that computer and get them out.

This software is ran in a large manufacturing environment so it is crucial to have the ability to know who is in and how many users are in.

We are having problems with the RLOCK() not getting released on some NT servers. Some sites the code runs without a hitch and some the NT server will not release the locks on the record.

Has anyone ran across this problem? Is there a way around it?

Thanks in advance.

Tommy Martin