?
Solved

Auto close Access after time period of non usage

Posted on 2011-03-15
8
Medium Priority
?
465 Views
Last Modified: 2012-08-14
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
Comment
Question by:JSSenior
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points
ID: 35137166
see the method discussed here
How to detect User Idle Time or Inactivity in Access
http://support.microsoft.com/?kbid=210297
0
 
LVL 2

Assisted Solution

by:IT-Factory
IT-Factory earned 1000 total points
ID: 35137169
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
 

Author Comment

by:JSSenior
ID: 35139218
capricorn1,

Thanks for this, it seems to work but not always, any ideas why this may be?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 75
ID: 35139690

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
 
LVL 75
ID: 35362573
JSSenior:
Just curious, did you try Peter's solution.  It always works ;-)

mx
0
 

Author Comment

by:JSSenior
ID: 35362614
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
 
LVL 75
ID: 35362634
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
 

Author Comment

by:JSSenior
ID: 35362658
It was a while ago from what i remember i had to mess woth code a bit.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

777 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