Access Database .ldb file stuck open on network

your network admin should be able to rip it striaght out whether the NOS thinks there are locks or not :-)

You could also try opening the file that the ldb is for and then close it again to see if it frees up. (you need delete permissions on the folder for that to even be possible).

Last resort ... rebooting the server should clear the lock that is preventing you from deleting it.

<<The lock file .ldb is stuck open within this folder and i cant get rid of it. >>

  You going to need to kill the session that is holding the lock or reboot the server.  You will be unable to delete the file as long as a lock is being held.

JimD

The network we are working on is a win xp network, so there is not really a cetrall server just uses a workgroup.

How doi kill the session??

-s-

Try this: http://ccollomb.free.fr/unlocker/ - I've used in the past to unlock files on client machines where they have been kept open.  Plus, it's free, which is my favourite price for software like this!!

Ad

<<How doi kill the session??>>

1. Right click on MyComputer
2. Select "Manage"
3. Click on "+" in front of shared folders.
4. Click on "Open Folders"

  Note which user(s) have the file open

5. Click on sessions.
6. Right click on the session(s) and disconnect.

JimD

Followed you instructions and it appears that there are no seesions open!!

What else would cause this to happen?

adaytay...

I instlled the unlocker and it confirmed the above by saying that no locking handle found.

-s-

<no points for me>

In that case, as Steve suggested, reboot the machine where you found the lockfile, and it should be removed.

<<What else would cause this to happen?>>

  It means it is opened locally.  You can use the instructions in the following thread:

  https://www.experts-exchange.com/questions/22423758/Delete-locked-file-that-nobody-is-accessing.html

  or as everything has said, simply reboot to clear the lock.

JimD

i have rebooted the machines several times, it wont clear. I have to leave this job for a couple of days now, i will let you know how i get on with you suggestions when i am back on site.

Thanks

Sam