Hello Gang,

I have an app that is shared using multiple workstations. They are using a peer to peer Network setup.

One of the workstations has the data, which is shared amongst the various other workstations.

Any of the workstations can run a program that is part of the app called "Nightly Series".
When this runs, it packs and reindexes the files, among other things. So, at some point, it needs exclusive use of the tables. When finished, this workstation exits the program totally, going to the Windows desktop. The other workstations are out of the app (back to the desktop) when Nightly Series runs on the other workstation.

****************************************

What I would like are 2 things..

1) Be able to know, when I select Nightly Series, that all of the other users have left the app (back to their desktop)....

2) If Nightly Series is running, not allow a user to enter the app on another workstation until Nightly Series is finished (on the workstation it is running on).

****************************************

I tried some ideas already. The last idea was based on Speedie's idea of having a table for keeping track of those logging in. When they login, they "LOCK" their record. When they leave the app, they "UNLOCK" their record (or if they crash out, this should unlock automatically).
When going into Nightly Series, I checked each record to see if it was "LOCKED" (by trying to Lock each record and seeing if it does not allow me to lock the record).

What ideas have you tried and worked?

Thanks!