ldb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Seems a bunch of ldb questions here lately

I've got an Access 2000 db on a fileserver and have a user hung on it. My company covers all 4 US contiguous time zones, so she's gone until morning. Is there really no way to get rid of the ldb and sharing issue with 2000? I saw someone posted that I could get in via Notepad to view the ldb files, but that's about it

And I can't add code modules from the Security FAQ until my user is out of the database. Any help would be appreciated

Thanks
Derek
 
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.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Derek Wittman said:
Seems a bunch of ldb questions here lately.

I've got an Access 2000 db on a fileserver and have a user hung on it. My
Click to expand...
company covers all 4 US contiguous time zones, so she's gone until morning.
Is there really no way to get rid of the ldb and sharing issue with 2000? I
saw someone posted that I could get in via Notepad to view the ldb files,
but that's about it.
And I can't add code modules from the Security FAQ until my user is out of
Click to expand...
the database. Any help would be appreciated!
 
Thanks, Cheryl - I've seen that you've posted this reply previously and so have already tried it. Unfortunately, I'm only the administrator for my database and am a lowly peon user to most of the systems in my company.

While it is tempting to make the db exclusive access only, I'm sure that this would be a worse situation than the one I am in now.

I'm open to any other ideas, of course.
Derek

----- Cheryl Fischer wrote: -----

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.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Derek Wittman said:
Seems a bunch of ldb questions here lately.
Click to expand...
company covers all 4 US contiguous time zones, so she's gone until morning.
Is there really no way to get rid of the ldb and sharing issue with 2000? I
saw someone posted that I could get in via Notepad to view the ldb files,
but that's about it.
 
Back
Top