>no, I am not using RLOCK, FLOCK. What I do is when they open specific document I just insert it in a table so if somebody else tries to open it they can see it but not Edit it. When the user saves then I unlock resetting the values in the table.
>bad Idea to do this?

I once used a technique like this in a situation where we had a problem with the users not shutting down the app before turning off their computers. If they didn't log out properly, they had to go see a supervisor to reset a flag so they could log back in.

If all you want to do is prevent other users from opening a document while someone is editing, you can either user pessimistic locking, or use an RLOCK on the record you add in your semaphore table. That way, if the computer or network crashes, the lock is released.