Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    force Front End Exits (Access XP)

    Does anyone know a quick and dirty way to force front ends to close or at least disconnect from a BE. I have remote "VPN" access to our LAN and often make modifications during off hours. Users sadly are not always diligent about closing Access at the end of the day. I'd love to be able to close the process but even if I could just disconnect them from the back end, I could at least modify it. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: force Front End Exits (Access XP)

    I didn't think of the following myself, but I have forgotten where I got it from.

    You need a form that is always open in the front end - a switchboard like form for example, or a dedicated form that may be hidden if desired. The form should be opened and closed with the database.

    The Timer Interval of the form is set to a convenient value, for instance 60000 (milliseconds). The On Timer event of the form reads a value from a table in the back end (using DLookup or by opening a record set); if this value is non-zero, you issue Application.Quit acQuitSaveNone. If you wish, you can issue a warning first (display a label in a conspicuous color) and delay the closing of the database for a few minutes.

    In the back end database, you have a table with one field and one record. The default value of the field is 0, but if you need to close the frontends, set the value temporarily to something else. You could do this manually, or use a special management form only available to you.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: force Front End Exits (Access XP)

    That is so slick. For some reason it seems devious too. I love it. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: force Front End Exits (Access XP)

    Theres a free example on Candace Tripp's - Access Developers Page

    Look for File: Detect and Logoff Idle Users

    27K Detects and ejects idle users after set time period.

Posting Permissions

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