Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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
0
jmatarranz
Asked:
jmatarranz
  • 3
  • 2
1 Solution
 
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 MVP, Access and Data Platform)Commented:
"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
 
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 MVP, Access and Data Platform)Commented:
"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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now