Force a user off the database

[dogdays]

AC 2003 & Ac 2007 Win7 32 bit

How do I force a user off of the current database using DAO?

tia Jack

 

[SydneyGeek]

You need a hidden form and an external text file.
See here

Denis

 

[dogdays]

Denis:
Thanks for the reply, I will use the MDE creation info.
I wish to force a specific user off of the database, not close the application. Is this possible?

Jack

 

[SydneyGeek]

Problem user?
I'm not sure how to target a specific account, but...

There are ways to check for activity, and boot users who haven't done anything for a set period of time.
Something like...

Hidden form with a txtTime field
Every 30 seconds (use the On Time event of the form, set to 30000) add 30 seconds (TimeSerial(0,0,30)) to txtTime
In the AfterUpdate event of each data entry form add some code to reset txtTime to 0
Back on the hidden form, check txtTime and when it reaches a threshold (15 minutes?), close the database -- just the front end.

That should close out any inactive users.

Denis

 

[Kreszch68]

For those in search for a method for this, I have implemented this into a generic login system I built a while ago (by lack of user-level security from Access 2007) . </SPAN></SPAN>
If you download the sample file, you’ll find a complete login system which can easily be implemented in your current project (it also includes a Rijndael module for encrypted storage of passwords).</SPAN></SPAN>
Regarding the force off users question. There is a control panel available where you can monitor all current users, and if you need one (or all) users to log off, you can simply tick them in the control panel. The user(s) receive a warning (the form says 5 minutes, but for the test version it’s actually 10 seconds </SPAN></SPAN>, see GLIS_Declarations for settings)) that the database will shut down. </SPAN></SPAN></SPAN>
The whole system is based on a BE/FE setup where the data is entered/changed only by forms (just like it should be anyway).

Here is the sample file : GLIS