tool removing files ldb

Posted on 2008-11-18
Last Modified: 2012-05-05
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
Question by:jmatarranz
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    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.

    LVL 75

    Accepted Solution

    "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:

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

    LVL 74

    Expert Comment

    by:Jeffrey Coachman


    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.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "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.

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now