>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

Chaim

As each user logs in, s/he locks a record in the maxuser table. When that user leaves the program, however they leave, the record is automatically unlocked.

I used a similar method years ago in clipper. Works like a charm.

Cheers
Bill