Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Corrupt database

Discussion in 'Information Technology' started by McDal, Jul 28, 2006.

  1. McDal

    McDal
    Expand Collapse
    Guest

    I apparently have a corrupt db and I've tried eveything I can think of to fix
    it with no avail. I've backed it up and then compact and repair it, relinked
    the tables...nothing works. I tried the jet utility that I found on
    utteraccess...that doesn't work. and another utility repair program that said
    it was successful but when I look at the new version there's nothing in it.

    I did find:

    1) a table named "Name Autocorrect Save Failures" in my bad version.

    2) I found another file with a different extension on it .....ldb. I'm
    assuming it's a locked copy of my database.

    I just want to get into the code behind the events so I can copy or print it
    out. My backup is a few days old and if I could just find a back way into
    the code I'd be ok.

    Any help would be so gratefully appreciated. (I've even installed service
    pack 2 and the updates from microsoft too).
     
  2. Loading...

    Similar Threads Forum Date
    Politics Power Corrupts but It Also Plays with Your Mind Breaking News Sep 22, 2013
    India Corruption rate in India is double of global average Breaking News Jul 9, 2013
    Partition Corruption in the Punjab... History of Sikhism Mar 24, 2013
    Bant Singh - A real anti-corruption hero Inspirational Stories Feb 27, 2013
    India US report slams India on corruption, social violence Breaking News May 25, 2012

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    At times like this, nothing beats a good backup.

    Tony Toews has an excellent web page on database corruption.
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Allen Brown also has excellent info on corruption.
    http://allenbrowne.com/ser-47.html

    I have a white paper in a Word document named Fix Corrupt Access Database
    towards the bottom this page:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp

    The .ldb file is not a locked copy of your database. Rather it's the file
    that keeps track of who is in the database so they both can't change the same
    record at the same time. With Access closed, delete this file.

    Go to Tools, Options, General Tab and turn off Name Autocorrect on all of
    your databases. IMHO it's a piece of do-do and the cause of many problems.
    While there turn off Compact on Close if enabled. You'll be glad that you did.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "McDal" wrote:

    > I apparently have a corrupt db and I've tried eveything I can think of to fix
    > it with no avail. I've backed it up and then compact and repair it, relinked
    > the tables...nothing works. I tried the jet utility that I found on
    > utteraccess...that doesn't work. and another utility repair program that said
    > it was successful but when I look at the new version there's nothing in it.
    >
    > I did find:
    >
    > 1) a table named "Name Autocorrect Save Failures" in my bad version.
    >
    > 2) I found another file with a different extension on it .....ldb. I'm
    > assuming it's a locked copy of my database.
    >
    > I just want to get into the code behind the events so I can copy or print it
    > out. My backup is a few days old and if I could just find a back way into
    > the code I'd be ok.
    >
    > Any help would be so gratefully appreciated. (I've even installed service
    > pack 2 and the updates from microsoft too).
     

Share This Page