-
February 22nd, 2011, 01:31 PM
#1
Help. How can I log people out of a database
I have one database that on our server that 5 people login to. Sometimes throughout the month I need then to logout so I can add, update ect.
Is there a simple code or way I can log everyone that’s logged into my database. I’ve seen code that will log people off if the database is split; I’m not ready to split the database.
I was thinking sometime like creating a hidden form and then do something to make the database close.
Any help would be appreciated
-
February 23rd, 2011, 02:19 AM
#2
Re: Help. How can I log people out of a database
Which database system is it?
-
March 3rd, 2011, 12:07 AM
#3
Re: Help. How can I log people out of a database
I also have this problem
Can this be done for
MS Access ?
MS SQL Server ?
-
March 3rd, 2011, 11:52 PM
#4
Re: Help. How can I log people out of a database
Depending on how harsly you want to do it in SQL Server, you can just kill all connections as you detach the database.
Otherwise - more "soft", depending on how people log in (if they log in via an application you control), then you can perhaps simply just kill connections to the database (sql server):
script for "kill active connections" and then prevent them from logging in.
However be careful doing something like this, because of how data can be inconsistent. It's much nicer to simply have an application the users go through control the connections of the database.
Last edited by Alsvha; March 3rd, 2011 at 11:55 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|