Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Location
    Kempton Park, South Africa
    Posts
    7

    Unanswered: Manage a LDB file

    Hi guys. I'm new to this forum. And I just want to find out if you guys can help me. I have created a Database for our company, and we have quite alot of users currently using the system. We are all running from Access 2003. Is there any programmes I can use to "manage" the LDB file. For instance, If I want to disconnect someone from the system. how will I be able to do this?
    Any help would be greatly appreciated.

    Thanx ppl!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there is no way, that Im aware of that out of the box allows you to kick off a user out of an MDB

    there is some code available that allows you to query the LDB file to find out who is logged in and on what computer

    Modules: LDB Viewer Form

    personally whenever I've had that issue Ive contacted the person directly by telephone. these routines also offer the capability to lock out future users of the MDB app

    there is some code around that allows you to send messages to logged on users (both in Access or whatever version of Windows you are on

    or scarily there is some software that allows you to take control of remote computers. we used to have a site where people ignored instructions so we 'just' took control of their desktops and killed any offending apps
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It's possible you could make this work if you have custom logins. I have custom logins and I know I can kick users out by selecting them and hitting Log Off in my AutoKick feature. They will be logged out in 5 minutes. This kind of thing can be done, but it is only doable by lots of development time and coding.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jul 2009
    Location
    Kempton Park, South Africa
    Posts
    7
    Bliksem, that will be awesome, Could you perhaps send me that code please!!

Posting Permissions

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