Solved

How to expel users from a database

Posted on 2011-09-30
8
162 Views
Last Modified: 2012-05-12
How can you use code to expel all users from a database?
0
Comment
Question by:Milewskp
  • 4
  • 3
8 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 36893217

I took Peter's FSD free app (http://www.peterssoftware.com/fsd.htm) ... and rolled it into a full blown app that works very well.

And related is this:

http://www.peterssoftware.com/isd.htm

These two will definitely do it for you.

mx
0
 
LVL 1

Author Comment

by:Milewskp
ID: 36893364
Thanks mx,
I use the same method described in the first link you provided to kick users out. It's surprising how similar the two are.

The second link you provided is about how to kick out inactive (stale) users. I was planning to use the same idea for my databases, but I believe I now have a better idea: Instead of kicking out stale users, I plan to put the database in sleep mode:
- A modal pop up form called Sleep Mode opens to tell the user the database is sleeping.
- All linked tables are converted to local tables with one record each (to prelude the database from getting huge).
- Any persistent connections that were established to other databases are broken.

If the user hits the Wake Up button, then
- The tables are converted back to linked tables.
- Persistent connections are re-established (for speed).
- the current form is requeried.
- the Sleep Mode form closes.

The database will close at midnight regardless of what the user does.

Of course, this method applies only if each user has their own front end.
0
 
LVL 75
ID: 36893582
Sounds interesting ... and it's sure making me sleepy just thinking about it :-)

mx
0
 
LVL 30

Expert Comment

by:hnasr
ID: 36895091
One simple Idea:

a table in the database, to schedule for closing the database.

User's copy processes a timer event every say 5 minutes.
Reads the table and checks for close time.
Warns the user to exit the application.
New users are not allowed to enter.
At the right time, a force exit is issued if user did not respond.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 1

Author Comment

by:Milewskp
ID: 36902960
Hi hnasr,
I think that's basially what http://www.peterssoftware.com/fsd.htm does. Maybe the reason we are all coming up with the same answer is that there really is only one good way to do it.
0
 
LVL 75
ID: 36904599
Peters app works! Guaranteed.

mx
0
 
LVL 1

Author Closing Comment

by:Milewskp
ID: 36904682
Thanks mx!
0
 
LVL 75
ID: 36904714
You are welcome.

mx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now