>Josh,
> How does your method take into account users who disconnect without logging out properly? It seems that if 20 users logged on and all crashed or disconnected improperly, your system would still think there were 20 users logged on, right?
> Regards Chaim

All locks will be released on records when the application is released whether from a crash or the normal quit command.

HTH.

John.