Welcome to SPN

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

Sign Up Now!

Corrupted Database

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

  1. BackAccess

    BackAccess
    Expand Collapse
    Guest

    Hello NewsGroup,

    I've been constructing an application UI using Access 2003. I've just
    started it early this morning so it hasn't been backed up as yet. There are
    no tables, queries, forms or report (didn't quite get to that stage). There
    are 10 class modules and 5 modules only. While coding away I got an error
    message, and Access had to restart, or gave me the option after the crash.

    Now when I try to open any of the module sheets I get the following
    disastrous message;

    "MS Office Access has detected corruption in this file. Try to repair the
    corruption, first make a backup copy of the file. Then, on the tools menu,
    point to the Database Utilities and click Compact and Repair Database. If
    you are trying to repair the corruption then you will need to recreate the
    file or restore it from a previous backup."

    | OK | Help |

    Well didn't quite get to the end of a working day to back up the database. I
    can't create another database and either import into it or export from the
    database to the new one cause I get the same error message. Can't export the
    module sheets otherwise I get the above error message.

    Is there anything I can do to retrieve the module files? Any kind of Hex
    file viewer or something as such I can retrieve the contents of the modules
    file. My lessons have been learnt!!!!

    Thank you all NewsGroup.

    - BackAccess (I truly have been back accessed this time)
     
  2. Loading...

    Similar Threads Forum Date
    Opinion How Could Punjab Police be Corrupted Then ? Punjab, Punjabi, Punjabiyat Dec 18, 2010
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Typically, databases start with tables then move to queries before any code
    is written. I'm not sure why you started by writing code, but I'll leave
    that for another post.

    First, always work on a copy of the database. Working on the original may
    make it impossible for a repair service to fix it.

    Download a copy of JetComp.exe:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

    Also have a look at the Microsoft KB article:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

    Then have a look at Tony Toews' Access Corruption FAQ at:

    http://www.granite.ab.ca/access/corruptmdbs.htm

    for some suggestions. Unfortunately, some corruption cannot be fixed - you
    may need to create a new database, import what can be salvaged, and recreate
    the rest.

    Although it's a paid service, Peter Miller does an outstanding job of saving
    corrupt databases. Try this URL:

    http://www.pksolutions.com
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads:
    http://www.datastrat.com
    http://www.mvps.org/access

    "BackAccess" <BackAccess@msnews.grp> wrote in message
    news:#6k0hTbdGHA.4108@TK2MSFTNGP03.phx.gbl...
    >
    > Hello NewsGroup,
    >
    > I've been constructing an application UI using Access 2003. I've just
    > started it early this morning so it hasn't been backed up as yet. There

    are
    > no tables, queries, forms or report (didn't quite get to that stage).

    There
    > are 10 class modules and 5 modules only. While coding away I got an error
    > message, and Access had to restart, or gave me the option after the crash.
    >
    > Now when I try to open any of the module sheets I get the following
    > disastrous message;
    >
    > "MS Office Access has detected corruption in this file. Try to repair the
    > corruption, first make a backup copy of the file. Then, on the tools

    menu,
    > point to the Database Utilities and click Compact and Repair Database. If
    > you are trying to repair the corruption then you will need to recreate the
    > file or restore it from a previous backup."
    >
    > | OK | Help |
    >
    > Well didn't quite get to the end of a working day to back up the database.

    I
    > can't create another database and either import into it or export from the
    > database to the new one cause I get the same error message. Can't export

    the
    > module sheets otherwise I get the above error message.
    >
    > Is there anything I can do to retrieve the module files? Any kind of Hex
    > file viewer or something as such I can retrieve the contents of the

    modules
    > file. My lessons have been learnt!!!!
    >
    > Thank you all NewsGroup.
    >
    > - BackAccess (I truly have been back accessed this time)
    >
    >
     
  4. BackAccess

    BackAccess
    Expand Collapse
    Guest

    Thanks Arvin very useful links ended up recoding it all from scratch,
    nothing would recover the modules. I know what you mean where databases
    start and finish, my part what to construct customised interface elements so
    I had API function and some more. I even found what ruined the entire
    database, make sure if you're ever doing the same to return a valid value
    for your "hook procedures" and API function parameters, otherwise Access
    just geos belly up.

    I'll keep those links though there very useful indeed. Thanks Arvin.

    Regards,
    - BackAccess

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:OfVWtZbdGHA.3364@TK2MSFTNGP05.phx.gbl...
    : Typically, databases start with tables then move to queries before any
    code
    : is written. I'm not sure why you started by writing code, but I'll leave
    : that for another post.
    :
    : First, always work on a copy of the database. Working on the original may
    : make it impossible for a repair service to fix it.
    :
    : Download a copy of JetComp.exe:
    :
    : http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
    :
    : Also have a look at the Microsoft KB article:
    :
    : http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
    :
    : Then have a look at Tony Toews' Access Corruption FAQ at:
    :
    : http://www.granite.ab.ca/access/corruptmdbs.htm
    :
    : for some suggestions. Unfortunately, some corruption cannot be fixed - you
    : may need to create a new database, import what can be salvaged, and
    recreate
    : the rest.
    :
    : Although it's a paid service, Peter Miller does an outstanding job of
    saving
    : corrupt databases. Try this URL:
    :
    : http://www.pksolutions.com
    : --
    : Arvin Meyer, MCP, MVP
    : Microsoft Access
    : Free Access downloads:
    : http://www.datastrat.com
    : http://www.mvps.org/access
    :
    : "BackAccess" <BackAccess@msnews.grp> wrote in message
    : news:#6k0hTbdGHA.4108@TK2MSFTNGP03.phx.gbl...
    : >
    : > Hello NewsGroup,
    : >
    : > I've been constructing an application UI using Access 2003. I've just
    : > started it early this morning so it hasn't been backed up as yet. There
    : are
    : > no tables, queries, forms or report (didn't quite get to that stage).
    : There
    : > are 10 class modules and 5 modules only. While coding away I got an
    error
    : > message, and Access had to restart, or gave me the option after the
    crash.
    : >
    : > Now when I try to open any of the module sheets I get the following
    : > disastrous message;
    : >
    : > "MS Office Access has detected corruption in this file. Try to repair
    the
    : > corruption, first make a backup copy of the file. Then, on the tools
    : menu,
    : > point to the Database Utilities and click Compact and Repair Database.
    If
    : > you are trying to repair the corruption then you will need to recreate
    the
    : > file or restore it from a previous backup."
    : >
    : > | OK | Help |
    : >
    : > Well didn't quite get to the end of a working day to back up the
    database.
    : I
    : > can't create another database and either import into it or export from
    the
    : > database to the new one cause I get the same error message. Can't export
    : the
    : > module sheets otherwise I get the above error message.
    : >
    : > Is there anything I can do to retrieve the module files? Any kind of Hex
    : > file viewer or something as such I can retrieve the contents of the
    : modules
    : > file. My lessons have been learnt!!!!
    : >
    : > Thank you all NewsGroup.
    : >
    : > - BackAccess (I truly have been back accessed this time)
    : >
    : >
    :
    :
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "BackAccess" <BackAccess@msnews.grp> wrote:

    >I even found what ruined the entire
    >database, make sure if you're ever doing the same to return a valid value
    >for your "hook procedures" and API function parameters, otherwise Access
    >just geos belly up.


    Ayup, Access can get confused easily on slightly flaky API calls.

    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