tool removing files ldb

     
Hi experts.

I have a cluster of files, this is swinging continuously and access all the files are locked with the ldb file, there are some tools to unlock the files ldb
jmatarranzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
jmatarranz,

First, lets define the ldb file.

1. This file does NOT "Lock" anything, and is not locked itself.
This file merely provides info on the current user's session while in a given database file.
So you don't need anything to "Unlock" these files because the are NOT locked.

2. Whenever you open an Access Database file, an ldb file is created, it is immediately deleted when you close the database normally.
If this file remains after the database is legitimately closed, it can usually be ignored, or deleted, with no ill effects.

3. The fact that you have accumulated a "Cluster" of these files says that there have been a great deal of "Abnormal terminations" of the database files.
This is the more perssing issue, as this can lead to corruption.

Please tell your users to notify you of any "Abnormal terminations" of a database file, either due to user error, or an issue with the database itself.

JeffCoachman
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"This file does NOT "Lock" anything,"

Actually, it does, noting that you cannot delete or move an MDB that has an associated LDB file.  And even an 'orphaned' LDB file can 'lock' an MDB - preventing design changes, etc.

You can check this out, however I have not quite found it to work on LDB files:

http://ccollomb.free.fr/unlocker/

Also ... here is an excellent free LDB viewer:

http://www.technipixel.com/accessldb.htm

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
DatabaseMX,

Thanks.

Have you found this to be fairly consistient across all versions?

I remember a few instances where I was able to Delete a DB with a ldb file.

Jeff
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"I remember a few instances where I was able to Delete a DB with a ldb file."

It depends on how the LDB was orphaned. Even occasionally here at work, the ldb viewer will show no one in the ldb, but ... I am unable to delete the LDB file and/or make any changes to the corresponding mdb. For about 2 weeks, the IT Dept was apparently moving some server folders to a new folder ... and for WHATEVER reason, when an MDB would close, the LDB file was not being deleted - nor could it be deleted manually!  It was very weird.

mx
0
Jeffrey CoachmanMIS LiasonCommented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.