Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Proliferating .ldb files

    I just looked at my Norton recycle bin and there are 87 copies of one Dbs .ldb file, from when I was in the Db for about 2 minutes doing virtually nothing. I opened and immediatley closed the Db and there were another 7 copies.
    I am using Access 2000 on win2000, the Db is split and it is the Data Db whose .ldbs are proliferating in the recycle bin.
    This seems really weird. Anyone have any ideas what is going on?
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proliferating .ldb files

    Why would the files be there at all? This isn't something Access is doing. When you leave a database, it automatically destroys the ldb file, and until then you can't delete it. What Norton product are you using? It sounds like it's stashing copies of the lock file in case you crash.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proliferating .ldb files

    Using Norton system works 2001. But all I have running is Norton Protected Recycle Bin. No other part of Sys Works is running.
    This doesn't happen with any other Db, just this one. Sure beats me!!
    Regards,
    Peter

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proliferating .ldb files

    I don't use that type of utility, so I can't be much help on it. However, when you see one database behaving differently from others, you have to start tracking down the differences in order to avoid the same problem in the future. I'd start by creating a whole new database and importing everything from that one into it. See if the new database does the same thing. If so, then it may be something about the way it was built that causes it. In that case, start looking specifically at what makes this database different from the others: were they all created in the same version, do they all have the same references set, are any using an activex control, are they all using the same object model (DAO or ADO), etc.
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Proliferating .ldb files

    Adding on to what Charlotte suggested, what is different about this database. Is it on a different drive? Is it in a different directory? What about the settings for the Norton utility? Does it allow you to specify drives, directories, and/or filenames to protect when deleted?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proliferating .ldb files

    I didn
    Regards,
    Peter

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Proliferating .ldb files

    I think what you are looking at is different than the Recycle Bin. The unerase utility just goes out to find all instances of a deleted file in your directory (that is filenames that contain a '?' as first character). These may or may not be recoverable. I wouldn't worry about it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •