Unattended Compact Repair

[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

 

['69 Camaro]

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.

 

[Arvin Meyer [MVP]]

#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