>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown