Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page