Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Unattended Compact Repair

Discussion in 'Information Technology' started by CaptainBly, Jul 28, 2006.

  1. CaptainBly

    CaptainBly
    Expand Collapse
    Guest

    I have a client where I set up a scheduled task that does a nightly
    compact and repair.

    I log the results of the compact/repair into a table that they can
    monitor and make sure it is running successfully.

    Inevitably, at least one or two times a week, someone doesn't log out
    of their front end program leaving the back end database I am trying to
    compact, locked and the compact fails.

    Is there a way to #1, determine who has left it open? I think I can
    read something in the LDB but have never done that before.

    #2, is there a way to "nicely" log them out of the database without
    damage to the database.

    Thanks in advance for any help with this.

    PZ
     
  2. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, PZ.

    > Is there a way to #1, determine who has left it open?


    Yes. Use the LDB Viewer or write an application that checks the Microsoft
    Jet UserRoster to determine which users are logged in. You may find a link
    to the LDB Viewer and other free diagnostic tools in the "Free Microsoft
    Access Troubleshooting Tools" section on this Web page:

    http://www.Access.QBuilt.com/html/links.html

    Sample code for this task in Access 2002 and 2003 is available on this Web
    page:

    http://support.microsoft.com/default.aspx?id=285822

    > #2, is there a way to "nicely" log them out of the database without
    > damage to the database.


    Please see the "Fix Its" section on the following Web page for a link to Tom
    Wickerath's tip, "How to kick users out of the database when they've been
    idle too long":

    http://www.Access.QBuilt.com/html/how-to_tips.html

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "CaptainBly" <paul@phoendev.com> wrote in message
    news:1151248367.220302.58940@m73g2000cwd.googlegroups.com...
    >I have a client where I set up a scheduled task that does a nightly
    > compact and repair.
    >
    > I log the results of the compact/repair into a table that they can
    > monitor and make sure it is running successfully.
    >
    > Inevitably, at least one or two times a week, someone doesn't log out
    > of their front end program leaving the back end database I am trying to
    > compact, locked and the compact fails.
    >
    > Is there a way to #1, determine who has left it open? I think I can
    > read something in the LDB but have never done that before.
    >
    > #2, is there a way to "nicely" log them out of the database without
    > damage to the database.
    >
    > Thanks in advance for any help with this.
    >
    > PZ
    >
     
  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    #1:

    http://www.mvps.org/access/modules/mdl0055.htm

    http://www.mvps.org/access/general/gen0034.htm

    #2:

    http://www.datastrat.com/Download/KickEm.zip
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "CaptainBly" <paul@phoendev.com> wrote in message
    news:1151248367.220302.58940@m73g2000cwd.googlegroups.com...
    >I have a client where I set up a scheduled task that does a nightly
    > compact and repair.
    >
    > I log the results of the compact/repair into a table that they can
    > monitor and make sure it is running successfully.
    >
    > Inevitably, at least one or two times a week, someone doesn't log out
    > of their front end program leaving the back end database I am trying to
    > compact, locked and the compact fails.
    >
    > Is there a way to #1, determine who has left it open? I think I can
    > read something in the LDB but have never done that before.
    >
    > #2, is there a way to "nicely" log them out of the database without
    > damage to the database.
    >
    > Thanks in advance for any help with this.
    >
    > PZ
    >
     

Share This Page