Results 1 to 10 of 10
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Force Disconnect (Access 2K/Win 2K)

    A user has logged into an access database and then gone off for a two day training course <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> (having locked their desktop) - does anybody know of any way to forcibly break a user connection, so I can make a modification <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>?

    I know in future to use a form timer to ensure that any inactivity forces the database to close!

    Kind regards

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    Turn their PC off at the wall <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Peter

  3. #3
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    Thanks - I had thought of that, but unfortunately they also have an open link to our TeraData Warehouse (over 2.5 billion rows of data!!) - and I really wouldn't want to be the one to potentially corrupt that gateway! <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23> <img src=/S/meltdown.gif border=0 alt=meltdown width=15 height=15>

    Cheers anyway!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Force Disconnect (Access 2K/Win 2K)

    There's a free download called Jet4Admin from the FMS Inc site that allows you to administer databases, including kicking users off, but it is an on-going administration tool, not a one-time use app.
    Charlotte

  5. #5
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    Thanks Charlotte - a great help (as always)!

    Peter - now that's what you might call a REAL answer!

    Cheers

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    Charlotte,

    Jet4Admin is no longer available as a free download as it is being replaced. Any chance you have a copy of the free utility that I could use?? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Force Disconnect (Access 2K/Win 2K)

    Sorry, but I don't have a copy anymore. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>
    Charlotte

  8. #8
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    I still have a copy of FMS Jet4Admin which I downloaded a while back when it was still a freebie. I never used it much because it didn't seem to provide you any way to work with secured databases, which rendered its usefulness, at least at work, to about zero. Tho' did seem to work OK when tested with non-secured db's. Presumably the new product that you have to shell out the big bucks for will not be lacking this capability. If interested I can fwd copy of file via e-mail, file size is appx 2.5 MB.

  9. #9
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    Mark,

    Please forward a copy to me via email.

    Thanks for the help.
    Regards,

    Gary
    (It's been a while!)

  10. #10
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Force Disconnect (Access 2K/Win 2K)

    File has been sent via e-mail as requested. Note: Not sent from same e-mail acct as listed in profile; subj line should read "FMS JET4ADMIN FILE".

Posting Permissions

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