can't delete .ldb file

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I have a split database system -- ADM_Prog.mdb on the
individual desktops and ADM_Data.mdb shared on the
server. A user locked up and had to close out using
ctrl/alt/del, leaving a "phantom" ADM_Data.ldb file on
the server. We checked to be sure no one else was in the
system, and then tried to delete the ldb file but get the
message "Cannot delete ADM_Data: Access is denied. Make
sure the disk is not full or write-protected and that the
file is not currently in use."

When I try to do a compact and repair on ADM_Data, it
says, "You attempted to open a database that is already
opened exclusively by user 'Admin' on
machine 'AJRUOB'... This is the machine I am working on!

How can I get rid of the .ldb file under these
circumstances? Have tried re-booting the AJRUOB machine -
- no luck. Rebooting the server is a major undertaking.
Anyone have any ideas??!!

Please reply to my email address -- speed is crucial.

Thanks!
--Wendy
 
Try this:

On the server (logged on with Administrator permissions), open a DOS window
(Run cmd) and navigate to the folder where the database is 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 "orphaned" 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.
 
Wendy,

I have encountered a similar problem several times in the
past. In one situation we found that the issue was caused
by a network switch not releasing the connection with the
server/database, and in another we found that a pc had a
bad ethernet card. I would recommend that you ask your
network department for help in troublshooting this issue.
They should be able to help you track down what is holding
a lock on the database. If you don't have a network
department then I would try turning all pc's off,
rebooting the server, turn on only 1 pc, try to compact
the database, and if successful bring all other pc's up.
If this doesn't resolve your problem then you will
probably need to talk with some networking people about
your issue.

Hope this helps!

Jay
 
If you have a network administrator, he/she should be able to forcibly close
the ldb file and delete it (without re-booting the server) so that you can
try to compact & repair the database.
 
Back
Top