I have a multi site multi user access database and want to know if there is a way I can kick everyone off the database? I have gotten errors where the mdb needs to be compact/repaired and there are still people who left it running on their desktop and aren't around to shut the thing down. I would like to have a message popup and say logging off in x minutes and then blamo they get botted. Zorro
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
boot off users
- Thread starter Zorro1265
- Start date
Check out the following website.
I have the same problem although ours is not a multi-site db. The way we 'fix' this is ... I have admin. priveleges on the server where the db resides. Then I can go to Control Panel -> Server -> In Use to see who is in the database. Then we e-mail, call, or page these individuals to warn them to log off. If they don't respond, there is an option in that same place (In Use) to close the resource (the database) or you could go to Users and disconnect the user(s)...Oh, btw, we are using an NT 4.0 terminal server.
andrewvanbeck
Programmer
I had this problem too, all I did was have a file on the fileserver, which I renamed whenever I wanted people to exit. All you need is a timer on the main menu which checks the file every minute, then you can force them to exit as friendly as you like, you just have to program a little routine to display a shut down warning.
The only problem is you really need a main menu system, which is no big deal as most multi-user databases would have that anyway.
Andrew.
The only problem is you really need a main menu system, which is no big deal as most multi-user databases would have that anyway.
Andrew.
MichaelRed
Programmer
This has (recently?) been discussed in these forums. I believe a search on "log off" will find one (or more) threads with discussion and code samples for this.
MichaelRed
mred@att.net
There is never time to do it right but there is always time to do it over
MichaelRed
mred@att.net
There is never time to do it right but there is always time to do it over
Andrewvanbeck -
I don't know if you'll see this, but...
Could you explain in more detail what you did to get users to log off. Is this file a separate file??? You have the Main Menu form of the database that is shared look at this other file???
I'm very interested in your solution.
Thanks,
Carie
I don't know if you'll see this, but...
Could you explain in more detail what you did to get users to log off. Is this file a separate file??? You have the Main Menu form of the database that is shared look at this other file???
I'm very interested in your solution.
Thanks,
Carie
- Status
Similar threads
