somebody please tell me how I delete an ".LDB" file

  • Thread starter Thread starter Trey Davis
  • Start date Start date
LDB is the lock file created whenever the MDB file is open. It normally
deletes itself after use. To delete it manually, kick out all users, then
simply select the file and delete it.
-Ed
 
WAIT!

what the!?

I went back into the computer and the "LDB" file is no longer there!

now what?
 
MDB is for babies.
it is unpredictable, unreliable and inefficient.

I can out-develop _ANY_ mdb developer; using a platform that is more
scalable; and it is the same price.

MDB is DED.

-Aaron
 
Did you not read what Ed wrote? The LDB file should self-destruct as soon as
all users are out of the database, but it will be undeletable if the
database is in use.
 
That is because everybody was out of the database.
Except when you open an mdb in exclusive mode, and ldb file is created. It
must be there for any other user to access the mdb while it is open. If an
mdb is open by one user and another user tries to open it and there is no mdb
they cannot open it.
 
WAIT!

what the!?

I went back into the computer and the "LDB" file is no longer there!

now what?
Click to expand...

Trey, did you bother to read Ed's response before replying to it?

John W. Vinson[MVP]
 
NO, it is DELETED, Trashed, Killed, no longer exists.

If all users have logged out of the database, Access automatically deletes
the .ldb file. It is a temporary file that is no longer needed.
 
but * I * want to delete it. ME. Can I change a setting somewhere on my
computer that tells Microsoft Access to not automatically delete the "LDB"
file?
 
No, you can't. You could write code to copy it with another extension, but
what exactly is your purpose for manually deleting it?
 
As far as I know, you cannot delete the .ldb if it is in use by Access.
There is no setting to tell Access not to delete the file.

If the file is still there after all users have exited the database, then
something "bad" happened. That could be that someone abnormally exited the
application (pulled the plug on the computer) , there was a network problem,
or Access crashed.
 
this makes me want to kill a wild boar.

Anwyay,

I just want to make sure that my computer doesn't have any files on there
that aren't necessary, such as the pointless "LDB" file. It's only purpose
is to discourage me from manually deleting it.
 
there is a LDB viewer utility that was released by microsoft; it is a
piece of something called 'JetUtils'

I dont have a URL; hope that helps.

BTW, if you were using a real database engine-- like SQL Server; and
Access Data Projects; for example-- then you would be able to backup
the database; even when people have it open.

this is yet another reason that MDB is completely and utterly OBSOLETE.

-Aarn
 
....you're Trey's older brother, right? ...the similarities are amazing.

William Hindman
 
wtf are you talking about? you want to come out and say that to my
face??

MDB is obsolete; and being able to use REAL TOOLS like Query Analyzer
and SSMS-- they make ADP development about 10 times easier than stupid
little MDB

maybe you kids should stop spreading misinformation about ADP and then
just _MAYBE_ id stop preaching the good word of ADP.

-Aaron
ADP Nationalist
 
Back
Top