Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2006
    Posts
    6

    Unanswered: Forced Shutdown Needed for Microsoft Access

    I am looking for a way to force shutdown and kick all users out of a Microsoft Access database. I know that it can be done by using Microsoft Visual but can not seem to get it to work. Does anyone know how?

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    A search of this forum turned up a few ideas...

    http://www.dbforums.com/search.php?searchid=362017

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The URL may work for you guys but it just presented a blank page for me. Its just a good job that dBforums hasn't lost its archive of postings....

    One technique uses a hidden form which periodically checks to see if a shutdown request has been stored in a table.

    To stop people opening the db.
    There is a method with A2000 on using the JET that came out at the same time where by you could stop new users opening the database - it required a magic GUI id and a bot of code. I came accross it in Access 2002 developer's handbook (enterprise edition I think). I'm sure it must be documented elsewhere on the web. The same book had a form which also showed the accessuser and computer id of the person using the Access application. If you network trolls know where the PC's are its quite easy to ring round and lock down the users

  4. #4
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    Hmmm. Okay, here are a couple of the threads from my previous link:

    http://www.dbforums.com/t677481.html

    http://www.dbforums.com/t644197.html

  5. #5
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    This any help?

    http://support.microsoft.com/kb/287655/en-us

    Or this

    http://www.candace-tripp.com/pages/a...downloads.aspx

    Look under Detect and log off idle users

  6. #6
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by randolphoralph
    I am looking for a way to force shutdown and kick all users out of a Microsoft Access database. I know that it can be done by using Microsoft Visual but can not seem to get it to work. Does anyone know how?
    Check out this site. It has such a program

    BUD
    http://www.fmsinc.com/products/Admin/index.asp

  7. #7
    Join Date
    Jan 2006
    Posts
    6

    macro unable to be change unless exclusive

    I have followed the link provided and I am able to make changes to the macro when others are in the database. Please help!

  8. #8
    Join Date
    Feb 2005
    Posts
    333
    I didn't read all of the links provided by other members but this is how I have done this in many dbs. I have a table, that I call admin, that contains a field with a yes/no type. Typically, I make this a hidden table. The I use a timer on my main form that checks the status of the admin table when the timer event fires. If the field is true, I do Application.Quit. This will allow you to boot everyone from your db. YOu can also check the status of this field on form load and if the field is true, then you can deny access to the db. You will be able to bypass the denial by using the shift+open trick.

  9. #9
    Join Date
    Jan 2006
    Posts
    6
    Ok I have gotten the admin table created and need to see how to get the timer to check the status of the admin table. I am not sure how to set the timer to check the field to see if true and then the application quit.

  10. #10
    Join Date
    Feb 2006
    Posts
    56

    Also found this.

    Hello again.

    I also found this out on the MS Knowledge Base

    Article ID : 304408
    Last Review : June 23, 2005
    Revision : 6.0

  11. #11
    Join Date
    Feb 2006
    Posts
    56
    anyone have advice for access 97 databases?

Posting Permissions

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