Results 1 to 6 of 6

Kick People out of the Database to make updates

  1. #1
    Ian Frost is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    11

    Kick People out of the Database to make updates

    Currently i have an access database that is shared with 50+ people. Before I started, the access database was not setup with a front/back end. Therefore when I need to make updates to the database, I need to be in it exclusively. This has been extremely difficult because coworkers leave the database open on their desktops throughout the weekend. Without a front/back end database to make updates, is there a way to kick users off, or have the ability to time out if access is inactive for more than a set period of time?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    5,635
    I had a table tConfig, it had various things the db used, but 1 was, a ForceLogoff check box.
    when a user changed record, or saved, or left a form , it would check this field, then

    Code:
    bExitAll = Dlookup("[ForceLogoff]","tConfig")
    if bExitAll then
      msgbox "All users must exit the db for updates"
      docmd.quit
    endif

  3. #3
    Ian Frost is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    11
    Thanks ranman256. I'm going to try to set something up with that code

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,347
    You need a table with a field that holds the kick out flag value - let's say value = 1. In the front end you need an always open form and in the On Timer event you need it to be checking the Kick Out table's value....with code that If =1 then....and shut things down...or do messages to users, etc.

    The admin person enters the 1 value to initiate kick out....

    No matter what it is messy and interruptive... but.....

  5. #5
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Feeding Doritos to a Tree
    Posts
    554
    I use the Admin Script Editor from iTripoli Script Form Deployment Tool. Since all Front Ends exist on the same spot for each PC("C:\PDS"). I run the command

    CMD /C DIR C:\PDS\TheDatabase.lccdb

    the command executes once for each machine selected in the interface(which is populated from Active Directory).

    It requires no $$$ as its a free tool. And it takes no database.

    You can also use similar

    CMD /C Taskkill /FI "WindowTitle eq TheDatabase*"

    against the PC's that showed "TheDatabase" as being opened, and that will close the front end.
    Patience serves as a protection against wrongs as clothes do against cold.

  6. #6
    DavidMcArthur is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2016
    Posts
    11
    Thanks for this! I will hopefully try and use it on my database!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Make Inserts Perform Like Updates
    By dgerundo in forum Forms
    Replies: 7
    Last Post: 11-25-2015, 07:14 AM
  2. Replies: 1
    Last Post: 06-04-2014, 07:23 AM
  3. Replies: 1
    Last Post: 02-09-2012, 10:49 AM
  4. Database Updates
    By avarusbrightfyre in forum Programming
    Replies: 1
    Last Post: 09-15-2010, 01:58 PM
  5. Replies: 0
    Last Post: 12-28-2009, 11:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums