Unable to delete .ldb

  • Thread starter Thread starter Marla
  • Start date Start date
M

Marla

Hello, occasionally we have an .ldb which "hangs" and we
are unable to delete it. It says there is a sharing
violation but there isn't. The only way I know to delete
this is to bounce the box which is inconvenient since it
is on a server. The permissions are fine.

Thoughts? Thanks.
 
When I have had this happen, I do the following:

On the server, open a DOS window and navigate to the folder where the
"orphaned or hung ldb files" are located. Type:

net file Then, press Enter

You should see a listing of all open files, each of which will have a number
(probably 6-digit) assigned to it. In the listing, you should also see the
login id of the user that opened the file. Write down the numbers
associated with each of the ldb files you need to delete.

Then, Type:

net file 987654 /delete

where 987654 is the number associated with an ldb file to be deleted.

Hope this helps,
 
In addition to Cheryl's advice, try to eliminate the reason for the .ldb
file. Stray .ldb files are often caused by faulty network hardware,
improperly exiting Access (i.e. using the power switch to turn off the
machine, using Ctrl+Alt+Delete to shut down Access, etc etc), and a few
other things. Google on "stray .ldb" or something similar for a host of
information on this.
 
Back
Top