T
Trey Davis
somebody please tell me how I delete an ".LDB" file
E
Ed Robichaud
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
deletes itself after use. To delete it manually, kick out all users, then
simply select the file and delete it.
-Ed
T
Trey Davis
WAIT!
what the!?
I went back into the computer and the "LDB" file is no longer there!
now what?
what the!?
I went back into the computer and the "LDB" file is no longer there!
now what?
A
aaron.kempf
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
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
B
Bill Mosca, Access MVP
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.
all users are out of the database, but it will be undeletable if the
database is in use.
J
John Vinson
Trey, did you bother to read Ed's response before replying to it?
John W. Vinson[MVP]
T
Trey Davis
Is it possible to create my own "LDB" file?
John Vinson said:
J
John Spencer
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.
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.
T
Trey Davis
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?
computer that tells Microsoft Access to not automatically delete the "LDB"
file?
B
Bill Mosca, MS Access MVP
No, it is deleted. Access creates the file when the database is opened in a
shared mode. The LDB file is what controls record lockin gso that 2 people
do not change a record at the same time.
There is a good article that downloads with the Jet Utilities file at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176670
shared mode. The LDB file is what controls record lockin gso that 2 people
do not change a record at the same time.
There is a good article that downloads with the Jet Utilities file at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176670
T
Trey Davis
so... how do I go inside the "LDB" file?
Bill Mosca said:
B
Bill Mosca, MS Access MVP
No, you can't. You could write code to copy it with another extension, but
what exactly is your purpose for manually deleting it?
what exactly is your purpose for manually deleting it?
J
John Spencer
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.
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.
T
Trey Davis
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.
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.
A
aaron.kempf
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
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
W
William Hindman
....is there a day care center for this community?
William Hindman
William Hindman
W
William Hindman
....you're Trey's older brother, right? ...the similarities are amazing.
William Hindman
William Hindman
A
aaron.kempf
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
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
M
Marshall Barton
ROFLMAO
--
Marsh
--
Marsh
William said:
R
Robin
I've just joined this group and I'm shocked 
What are these respected MVPs doing cross-posting? Did someone change the
rules and I missed it?
What are these respected MVPs doing cross-posting? Did someone change the
rules and I missed it?