>People ,
>
>
>When i want to update my datab or something like that
>I want to make sure everyone is out of my database
>Can somebody give me some tips avout doing that in a save , neat way
>I am using datasessions etcetera.
>
>Thanks ,
>David van der Vliet


If we want everyone out of our database, we place a file in the common server area that is checked by a timer in our application. If the file is found, our application pops up a custom messagebox stating that the administrator requires exclusive use of the system and asks the user to close the application. If the Ok is not pressed in a certain amount of time, the messagebox presses it automatically (timer) and attempts to run the application exit.

The only problem with the design occurs if a user has uncommitted changes to a table... we don't assume a save/cancel. The system simply waits on the user to make the selection.

Once all our password records are unlocked (everyone is out) we do whatever processing is necessary.


Wayne