[AccessD] Access Lock File problem

Dear Forum Folks:

We have an access order management application here that has a front-end
installed on 10 computers and a back-end that resides on the server.  We
compact/backup the back-end mdb every day - usually with no problem.  But
the compact/back-end, of course requires that only ONE computer can be
accessing the back-end mdb, and every once in awhile the person running the
compact forgets to close out the app on one of the computers.  When that
happens it seems like the lock file gets 'locked' for good;  even after
making sure EVERYONE is out of the app, access thinks the mdb is locked.

The only solution I've found so far is to re-boot the server and then delete
the lock file.  This seems like an in-elegant and time-wasting solution to
me;  is there some setting I'm missing in Access that's causing this issue?
Is there some other way I can release the ldb file without having to
re-boot?

Thanks!

Janet Erbach
IT Prognosticator
Natural Healthy Concepts