.LDB Question

[John C.]

I have not been able to perform database maintenance due
to the database is "in-use".

I have a subroutine that reads the LDB file and gives the
computer's ID.

I have gone to each computer, ensured no-one was logged
on, and have even shutdown and de-energized the computer,
but the computer ID remains in the LDB file.

I can not delete the LDB file because it is "in-use".

Help me Santa....PLEASE.

Thank YOU!

 

[Cheryl Fischer]

To clear a resistant LDB file from the server, try this:

On the server (logged on with Administrator permissions), open a DOS window
and navigate to the folder where the resistant LDB file 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 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.

hth,