Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2002 sp3, is there any way to have a database automatically close at a certain time if a user has inadvertantly left it open?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Hi Judy,

    The thread Shut down Access After a Fixed Period of Inactivity deals with a similar subject, and references a MS technet article that contains the implementation details. In you case you would change the code to look at the time of day, but you might also want to use an inactivity timer as well so if someone is working late you don't pull the plug on them - so to speak.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Quote Originally Posted by JudyJones View Post
    Using Access 2002 sp3, is there any way to have a database automatically close at a certain time if a user has inadvertantly left it open?
    I keep a hidden form open in the frontend, that uses the timer event to check (every 2 minutes) an EveryoneOut flag I keep in the backend. If flag is true, then the form makes itself visible (which shows a label in big letters) and tells user he has 2 minutes to finish before the database closes. You could use same principle to also look at the time of day.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am just getting back to work after a week off because of a 20" snowfall. Thanks for the reference. I'll try it out and see if I can make it do what we need.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •