C
CaptainBly
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
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