Welcome to SPN

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

Sign Up Now!

access data corruption

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

  1. davidp

    davidp
    Expand Collapse
    Guest

    I have several unrepairable databases, using byte editor, I found that part
    of the file is missing. equals unrepairable database.

    How does access store the information so I can write my own data extraction
    tool to grab the data.
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    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

    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "davidp" wrote:

    > I have several unrepairable databases, using byte editor, I found that part
    > of the file is missing. equals unrepairable database.
    >
    > How does access store the information so I can write my own data extraction
    > tool to grab the data.
     
  4. davidp

    davidp
    Expand Collapse
    Guest

    Jerry, I know how to do link table recovery, etc. what I'm talking about is
    part of the file is missing, ie, no end of file marker, no end of record
    marker, part of or all of msys table is missing (i think). How is the data
    stored in the database so I can write my own extraction routine to save the
    data?

    "Jerry Whittle" wrote:

    > 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
    >
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "davidp" wrote:
    >
    > > I have several unrepairable databases, using byte editor, I found that part
    > > of the file is missing. equals unrepairable database.
    > >
    > > How does access store the information so I can write my own data extraction
    > > tool to grab the data.
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Microsoft has never released specs. to it.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "davidp" <davidp@discussions.microsoft.com> wrote in message
    news:0733D7C5-D84A-4532-988C-EACBC30CFB67@microsoft.com...
    > Jerry, I know how to do link table recovery, etc. what I'm talking about

    is
    > part of the file is missing, ie, no end of file marker, no end of record
    > marker, part of or all of msys table is missing (i think). How is the

    data
    > stored in the database so I can write my own extraction routine to save

    the
    > data?
    >
    > "Jerry Whittle" wrote:
    >
    > > 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
    > >
    > > --
    > > Jerry Whittle
    > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    > >
    > >
    > > "davidp" wrote:
    > >
    > > > I have several unrepairable databases, using byte editor, I found that

    part
    > > > of the file is missing. equals unrepairable database.
    > > >
    > > > How does access store the information so I can write my own data

    extraction
    > > > tool to grab the data.
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    davidp <davidp@discussions.microsoft.com> wrote:

    >I have several unrepairable databases, using byte editor, I found that part
    >of the file is missing. equals unrepairable database.
    >
    >How does access store the information so I can write my own data extraction
    >tool to grab the data.


    The closest thing to any such specs is the following open source tool.
    However be warned that this is not a simple task and could take you
    weeks.

    MDB Tools is a set of open source libraries and utilities to
    facilitate exporting data from MS Access databases (mdb files) without
    using the Microsoft DLLs. In other words they are reverse engineering
    the layout of the MDB file. mdbtools.sourceforge.net

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page