Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Auto close Access after time period of non usage

Is there anything that can be added to an MS Access Database that closes the Apllication if there has been a 30min period of non usage?
0
JSSenior
Asked:
JSSenior
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
see the method discussed here
How to detect User Idle Time or Inactivity in Access
http://support.microsoft.com/?kbid=210297
0
 
IT-FactoryCommented:
Use this on a form

sub form_load()
  Me.timerinterval = 30000
end sub

sub from_timer()
  me.close()
end sub

Open in new window

0
 
JSSeniorAuthor Commented:
capricorn1,

Thanks for this, it seems to work but not always, any ideas why this may be?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:

This works ... I've tested it:

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

As does this (related):

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

Both are free ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
JSSenior:
Just curious, did you try Peter's solution.  It always works ;-)

mx
0
 
JSSeniorAuthor Commented:
I never got to it, unfortunately so many other things have taken priority. Hope to get back on it next week, thanks for the info
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Also curious how the Assisted answer closes Form after no activity. Nothing in that code resets the time if activity *occurs*.  Did you test this?

mx
0
 
JSSeniorAuthor Commented:
It was a while ago from what i remember i had to mess woth code a bit.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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