disconnect users from access db

Posted on 2014-08-06
Last Modified: 2014-08-06
I have an EXCEL pivot file that refreshes uses a query in an ACCESS db.  I need to edit that DB but someone is using the EXCEL file and the db opens as read-only.  Is there a way to "kickoff" the users?
Question by:szadroga
    LVL 12

    Assisted Solution

    We have a free utility called "Force Shut Down" that enables you to kick all users off of a multi-user Access application. More info is here:
    LVL 56

    Accepted Solution

    If the data store is a JET/ACE db, the short answer is no.  

      You need to build something into the app to force users off.  A force disconnect outside of that can corrupt the DB.

      JET/ACE does have a passive shutdown feature, which when enabled will stop new connects to a DB, but it doesn't touch existing users.

     Your best bet is to build something in along the lines of what Peter did.

     Also, you may want to add the ability for the app to detect idle time, and if longer than xx minutes, force a quit (again built into the app):

    ACC: How to Detect User Idle Time or Inactivity


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now