[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

How do we force an automatic sign off after a few minutes of no activity?

We have Access and Excel programs that are used by many employees in the office.  At times, some of them will leave the file open and go to lunch or minimize the file, forget about it and work on other files or projects which can hinders other users.  I would like a procedure that will 1) ask the user if they would like to continue to be signed on the program, 2) if they say no or if the program receives no answer to the question, the program will automatically save the file with all changes and close so that others may use it and 3) If the program is closed, a statement will be displayed on the screen saying that it was closed because of "No Activity".  The time-out test could be something like 15-minutes (more or less).  Any suggestions?  Since I have never made a program like this, please send the steps and state where they would be placed in the program.  Also, is there a "time-out" process already built in that can be used that I don't know about?

Thanks.
WRS
0
sherman6789
Asked:
sherman6789
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Here you go ... free - and it works:

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


Related:

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

mx
0
 
xDUCKxCommented:
Removed cause other answer was better
0
 
sherman6789Author Commented:
Thank you DatabaseMX for your suggestion on forcing a file to shutdown if a user leaves the file open and makes no changes for a 15-minute period.  The programs looks great and it appears to be a perfect system to do what we want done.

However, I work in a high security federal government building where outside or external programs and systems are blocked and not allowed to work or download.

I will keep this program available for people who need this shutdown ability but are not located in a system that has extra security protection.

Do you have a suggestion on how a file can be shut down after no activity?  The steps need to be part of the Access or Excel file or program using the installed keys and the built-in controls.

To: xDUCKx, please write the suggestion that you were going to attach but changed your mind after you read the program sent in by DatabaseMX.  I agree that that program seems to be very, very good but I must find another way to accomplish the shut down.

Thanks again.

WRS
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
Elton PascuaCommented:
Here's a start with several customizations. I hope it fits your needs.

http://www.vbaexpress.com/forum/showthread.php?t=33711

Open in new window

0
 
sherman6789Author Commented:
Thanks Techfanatic,

I have asked the computer security office to determine if it is ok for me to use this process.  I will reply soon.  Thanks.

WRS
0
 
sherman6789Author Commented:
Good news.  Our managers have determined that the suggestions given by DatabaseMX and Techfanatic may be used for various programs in the office.  I am, therefore, awarding the points to both experts.  Thank you for your assistance.

WRS
0
 
sherman6789Author Commented:
Thank you for your assistance.  Both solutions from  techfanatic and DatabaseMX have been approved as working solutions in our office.  They must be reaproved each time that they are considered for used.  They do answer the pending question.  

We want to also thank Experts-Exchange for providing a means for us to get the information that we need.

WRS
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Cool.
0
 
sherman6789Author Commented:
We have a problem using outside programs in this governemt office because of the security requirements.  However, our office along with security have determined that both of these programs may be use under certain controlled circumstances.

Thank you for your assistance.

WRS
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now