Welcome to SPN

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

Sign Up Now!

missing records

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

  1. KC178

    KC178
    Expand Collapse
    Guest

    All of a sudden, several records have disappeared from my Access database,
    which I have been using for over 3 years. They are totally gone, and I can't
    figure out why or how. I am the only person using this database. Could a
    thunderstorm with lightning have affected it? Or is this some type of
    corruption?
    Is there any way to get the missing records back? I don't have a good
    backup copy.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Missing records delay CBI probe into riots of 1984 (Khaleej Times) Breaking News Mar 18, 2006
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Heritage The curious case of Maharaja's 'missing' painting History of Sikhism Oct 29, 2013
    India Half of the missing children in 2013 remain untraced in India Breaking News Sep 3, 2013
    Note to admin: Missing post Literature Jul 7, 2013

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Re: missing records -- query? compare current and backup, decompile

    Perhaps the records are not gone... are you using a query to display
    them? If so, perhaps they are simply not showing. Are you comparing
    the number of records in each TABLE to what you used to have?

    although this information won't help you now, it is something that would
    be highly useful to add to anything else you develop or work with in the
    future so you can do better comparisons:

    *** Tracking date record was created or updated ***

    Add these 2 fields to all your tables (except lookups) and make them the
    last 2 fields.

    DateCreate, date, DefaultValue = Now()
    DateUpdate, date – set on the form BeforeUpdate event

    the best way to use the DateCreate field is to set a default value of
    =Now()
    in the table design.

    For DateUpdate, make sure it is on your form (I put it in the form
    footer and LOCK it. Then, use the Form BeforeUpdate event to set the value

    me. DateUpdate = now()

    '~~~~~~~~~~~~~~~~

    another thing to do is to compare what is common with the missing
    records by linking to a backup of the table in your database and using
    queries to compare them

    '~~~~~~~~~ Decompile ~~~~~~~~~

    if the database has gotten corrupted, try decompiling the database

    make an icon with this as its target:

    "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
    "C:\path\filename.mdb" /decompile

    if your Access program is not located in the directory specified, make
    the appropriate substitution

    after you decompile, compile it if you have any code and then do
    compact/repair

    '~~~~~~~~~ ~~~~~~~~

    you can also make a "generic" decompile icon where the next database you
    open will be decomipled...

    ie:
    "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /decompile


    Warm Regards,
    Crystal
    *
    :) have an awesome day :)
    *
    MVP Access



    KC178 wrote:
    > All of a sudden, several records have disappeared from my Access database,
    > which I have been using for over 3 years. They are totally gone, and I can't
    > figure out why or how. I am the only person using this database. Could a
    > thunderstorm with lightning have affected it? Or is this some type of
    > corruption?
    > Is there any way to get the missing records back? I don't have a good
    > backup copy.
    >
     

Share This Page