.ldb file not removed

[Lakshman]

I have an access application that I have copied on to a
network share on my server. Whenever I open the file to
edit it(hold the shift key and open the file) from one
machine, it won't let me open it from another machine
even though the file is closed on the original machine.
That is it does not remove the lock even though the file
has been closed on the original machine. Has anyone else
faced this problem. Any help or pointers in the right
direction would be greatly appreciated.
Lakshman

 

[Joan Wild]

I have an access application that I have copied on to a
network share on my server. Whenever I open the file to
edit it(hold the shift key and open the file) from one
machine, it won't let me open it from another machine
even though the file is closed on the original machine.
That is it does not remove the lock even though the file
has been closed on the original machine. Has anyone else
faced this problem. Any help or pointers in the right
direction would be greatly appreciated.

Ensure that the user you are logged in to Windows as, has delete permission
on the folder where the mdb is.

 

[Ken Snell]

I have noted at times that the lock will not be removed until the other PC
actually closes ACCESS itself, not just the database. Try that and see if it
works.

Otherwise, so long as you are sure there are no users in the file, you can
delete the .ldb file and then open the file.

Note: never share an ACCESS front end database! Always split your database
into a front end (forms, queries, reports, linked tables) and a back end
(tables). Give every user his/her own copy of the front end on his/her PC.
Put the backend on a drive accessible to all users. Backends can be shared;
front ends are not to be shared.