Locking File Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bunky - 04 Jun 2007 18:01 GMT

With direction from some fine MVPs, I was able to find a program that will
boot users off the database when I need to. For that, I thank you
tremendously. Last Friday however, it keep telling me that others were still
logged into the system. I viewed the locking file and saw that I had a
couple of entries. Since I have not been able to clone myself, I knew I was
NOT on the database. I have done some of the reading here regarding this
subject but have not been able to find a method whereby I could delete this
locking file when I know it is safe. Any Ideas how to accomplish this?

Thank you for your assistance!

Reply to this Message

Douglas J. Steele - 04 Jun 2007 18:25 GMT

Realistically, you can't delete it unless it's safe to do so: Windows won't
let you. In other words, if you can delete it, it's safe to.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> With direction from some fine MVPs, I was able to find a program that will
> boot users off the database when I need to. For that, I thank you
[quoted text clipped - 9 lines]
>
> Thank you for your assistance!

Reply to this Message

Bunky - 04 Jun 2007 18:36 GMT

But if I KNOW it is safe but the locking file says no, you're saying I'm
stuck? Is there nothing I can do to gain exclusive access?

> Realistically, you can't delete it unless it's safe to do so: Windows won't
> let you. In other words, if you can delete it, it's safe to.
[quoted text clipped - 12 lines]
> >
> > Thank you for your assistance!

Reply to this Message

Douglas J. Steele - 04 Jun 2007 18:50 GMT

Doesn't matter what you think, it's what Windows thinks! <g>

Perhaps someone quit the application by quitting Access, as opposed to
getting out of the application properly, or there could be some other reason
why Windows thinks there's still a connected thread. Sometimes it's actually
necessary to reboot the server to correct the problem.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> But if I KNOW it is safe but the locking file says no, you're saying I'm
> stuck? Is there nothing I can do to gain exclusive access?
[quoted text clipped - 19 lines]
>> >
>> > Thank you for your assistance!

Reply to this Message

Bunky - 04 Jun 2007 20:45 GMT

Thank you, Doug. I wasn't trying to argue with you; just thought there
should be an easy way but alas. . . Thanks for you assistance! It is
appreciated!

> Doesn't matter what you think, it's what Windows thinks! <g>
>
[quoted text clipped - 26 lines]
> >> >
> >> > Thank you for your assistance!

Reply to this Message

Bunky - 29 Jun 2007 22:46 GMT

Doug,

Just one more question on this subject if I may.

When you are saying quitting Access instead of getting out properly, are you
saying using the 'Big red X' at the upper right hand corner of the screen is
a no-no? Or doing the 'File>Exit' is a no-no. I have been telling people to
use the 'File>exit' method but just want to make certain.

Thank you!

> Doesn't matter what you think, it's what Windows thinks! <g>
>
[quoted text clipped - 26 lines]
> >> >
> >> > Thank you for your assistance!

Reply to this Message

Douglas J. Steele - 30 Jun 2007 01:54 GMT

The "Big red X" is a common culprit, as is shutting down Windows.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Doug,
>
[quoted text clipped - 49 lines]
>> >> >
>> >> > Thank you for your assistance!

Reply to this Message