Welcome to SPN

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

Sign Up Now!

Mystery loss

Discussion in 'Information Technology' started by rjkardo@gmail.com, Jul 28, 2006.

Tags:
  1. rjkardo@gmail.com

    rjkardo@gmail.com
    Expand Collapse
    Guest

    Hello,
    One of my coworkers has a very simple Access database.
    Recently, he changed the name of the main/only table.
    Somehow he seems to have lost all of the data in this tables.
    The db shows up in windows as having 18.5 mb, but there is nothing in
    the only table.
    If I do a compact/repair, it shows up as being 216K.

    Is there something I am missing? Is there anyway that the data is there
    and we are not seeing it? I have Hide Tables turned off, so it is not
    there.
    I am not a regular Access user, so there may be something key that I am
    missing.
    Any help would be appreciated.

    Rodjk #613
     
  2. Loading...

    Similar Threads Forum Date
    USA How Police Identified Severed Head After 24-Year Mystery Breaking News Mar 29, 2013
    Mystery Of Meaning Of Death In Sikhism Questions and Answers Dec 15, 2012
    Pace Bowling: Indian Mystery, Indian Obsession Sports & Fitness Aug 29, 2011
    Judaism What is the Greatest Mystery? Interfaith Dialogues Jul 18, 2011
    Ganga Sagar: History, Mystery, Legend, Devotion History of Sikhism Oct 3, 2010

  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    <rjkardo@gmail.com> wrote in message
    news:1148007347.980436.309350@j73g2000cwa.googlegroups.com
    > Hello,
    > One of my coworkers has a very simple Access database.
    > Recently, he changed the name of the main/only table.
    > Somehow he seems to have lost all of the data in this tables.
    > The db shows up in windows as having 18.5 mb, but there is nothing in
    > the only table.
    > If I do a compact/repair, it shows up as being 216K.
    >
    > Is there something I am missing? Is there anyway that the data is
    > there and we are not seeing it? I have Hide Tables turned off, so it
    > is not there.
    > I am not a regular Access user, so there may be something key that I
    > am missing.
    > Any help would be appreciated.
    >
    > Rodjk #613


    It sure doesn't sound good. That compacted size is consistent with a
    database containing an empty table or two, depending on the number of
    fields in the table(s). I'm inclined to doubt that all your friend did
    was rename the table. Did he describe indetail his exact actions?

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. rjkardo@gmail.com

    rjkardo@gmail.com
    Expand Collapse
    Guest

    Dirk Goldgar wrote:
    > <rjkardo@gmail.com> wrote in message
    > news:1148007347.980436.309350@j73g2000cwa.googlegroups.com
    > > Hello,
    > > One of my coworkers has a very simple Access database.
    > > Recently, he changed the name of the main/only table.
    > > Somehow he seems to have lost all of the data in this tables.
    > > The db shows up in windows as having 18.5 mb, but there is nothing in
    > > the only table.
    > > If I do a compact/repair, it shows up as being 216K.
    > >
    > > Is there something I am missing? Is there anyway that the data is
    > > there and we are not seeing it? I have Hide Tables turned off, so it
    > > is not there.
    > > I am not a regular Access user, so there may be something key that I
    > > am missing.
    > > Any help would be appreciated.
    > >
    > > Rodjk #613

    >
    > It sure doesn't sound good. That compacted size is consistent with a
    > database containing an empty table or two, depending on the number of
    > fields in the table(s). I'm inclined to doubt that all your friend did
    > was rename the table. Did he describe indetail his exact actions?
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)


    Hello Dirk,
    Thanks for the response.
    I am working in Kabul, Afghanistan so getting help is not easy.
    :)

    I think there is more to the story than I was told; all he said was
    that there was a power outage, and when the system came back up the
    table was still there...he used it for a while and closed it down. When
    he reopened it, the query he had would not work. So I looked at it,
    noticed the renamed table, and changed the query. Still nothing.
    Then I looked at the table...and there was nothing in it.

    IDK if that helps any, but thanks again.
    Rodjk #613
     
  5. scubadiver

    scubadiver
    Expand Collapse
    Guest

    I have just seen this message and may I have this opportunity to commend you
    on your bravery.

    What is Kabul like these days? Just thought I'd ask.

    "rjkardo@gmail.com" wrote:

    >
    > Dirk Goldgar wrote:
    > > <rjkardo@gmail.com> wrote in message
    > > news:1148007347.980436.309350@j73g2000cwa.googlegroups.com
    > > > Hello,
    > > > One of my coworkers has a very simple Access database.
    > > > Recently, he changed the name of the main/only table.
    > > > Somehow he seems to have lost all of the data in this tables.
    > > > The db shows up in windows as having 18.5 mb, but there is nothing in
    > > > the only table.
    > > > If I do a compact/repair, it shows up as being 216K.
    > > >
    > > > Is there something I am missing? Is there anyway that the data is
    > > > there and we are not seeing it? I have Hide Tables turned off, so it
    > > > is not there.
    > > > I am not a regular Access user, so there may be something key that I
    > > > am missing.
    > > > Any help would be appreciated.
    > > >
    > > > Rodjk #613

    > >
    > > It sure doesn't sound good. That compacted size is consistent with a
    > > database containing an empty table or two, depending on the number of
    > > fields in the table(s). I'm inclined to doubt that all your friend did
    > > was rename the table. Did he describe indetail his exact actions?
    > >
    > > --
    > > Dirk Goldgar, MS Access MVP
    > > www.datagnostics.com
    > >
    > > (please reply to the newsgroup)

    >
    > Hello Dirk,
    > Thanks for the response.
    > I am working in Kabul, Afghanistan so getting help is not easy.
    > :)
    >
    > I think there is more to the story than I was told; all he said was
    > that there was a power outage, and when the system came back up the
    > table was still there...he used it for a while and closed it down. When
    > he reopened it, the query he had would not work. So I looked at it,
    > noticed the renamed table, and changed the query. Still nothing.
    > Then I looked at the table...and there was nothing in it.
    >
    > IDK if that helps any, but thanks again.
    > Rodjk #613
    >
    >
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    rjkardo@gmail.com wrote:
    > Hello,
    > One of my coworkers has a very simple Access database.
    > Recently, he changed the name of the main/only table.
    > Somehow he seems to have lost all of the data in this tables.
    > The db shows up in windows as having 18.5 mb, but there is nothing in
    > the only table.
    > If I do a compact/repair, it shows up as being 216K.
    >
    > Is there something I am missing? Is there anyway that the data is
    > there and we are not seeing it? I have Hide Tables turned off, so it
    > is not there.
    > I am not a regular Access user, so there may be something key that I
    > am missing.
    > Any help would be appreciated.
    >
    > Rodjk #613


    I hope the compact and repair was done to a copy of the original table
    not the original. If you still have the original full size, you may be able
    to get the data recovered by one of the outfits that do that kind of work.
    Do a little Goggling and you should be able to find one. I don't know what
    they charge.

    If you do have that original, you could try making a copy and then try
    just a repair and see what happens. You also may want to take a look at
    hidden objects and see if there is any interesting tables showing up as
    hidden.

    Sorry to say this is another good reason to make sure you have a current
    back up at all times.

    --
    Joseph Meehan

    Dia duit
     

Share This Page