Welcome to SPN

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

Sign Up Now!

How can I recover a deleted column?

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

  1. Peggy

    Peggy
    Expand Collapse
    Guest

    I was working in my Access when all of a sudden a column disappeared. I went
    to a report and the info is missing off that page as well. How can I recover
    the lost column?
     
  2. Loading...

    Similar Threads Forum Date
    India Two Stolen Sikh Scriptures Recovered in Bihar Breaking News Sep 16, 2013
    USA Slow Recovery at US Sikh Temple Breaking News Jan 14, 2013
    S Asia Prayers offered for Pakistan girl's recovery Breaking News Oct 11, 2012
    USA Viral photo helps 19-year-old arthritic dog recover Breaking News Sep 28, 2012
    India Jalandhar: Weapons recovered from SGPC member's house Breaking News Sep 24, 2012

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Peggy wrote:
    > I was working in my Access when all of a sudden a column disappeared.
    > I went to a report and the info is missing off that page as well.
    > How can I recover the lost column?


    First make a copy of the database and work with the copy not the
    original

    Open the copy and see if you can do a repair and compact. (See the
    tools menu)

    Does that help?

    --
    Joseph Meehan

    Dia duit
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

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

    >I was working in my Access when all of a sudden a column disappeared. I went
    >to a report and the info is missing off that page as well. How can I recover
    >the lost column?


    Is the width of the column in the datasheet view set to zero?

    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
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Tony Toews wrote:
    > Peggy <Peggy @discussions.microsoft.com> wrote:
    >
    >> I was working in my Access when all of a sudden a column
    >> disappeared. I went to a report and the info is missing off that
    >> page as well. How can I recover the lost column?

    >
    > Is the width of the column in the datasheet view set to zero?


    I should of thought of that. It that the voice of experience speaking?
    :)

    >
    > Tony


    --
    Joseph Meehan

    Dia duit
     
  6. Peggy

    Peggy
    Expand Collapse
    Guest

    I did that and nothing changed or came back. Thanks so much for the help,
    tho! I know very little about this program as it was set up by an assistant
    and she is gone. Guess it is time for me to take a class or two on Access!

    "Joseph Meehan" wrote:

    > Peggy wrote:
    > > I was working in my Access when all of a sudden a column disappeared.
    > > I went to a report and the info is missing off that page as well.
    > > How can I recover the lost column?

    >
    > First make a copy of the database and work with the copy not the
    > original
    >
    > Open the copy and see if you can do a repair and compact. (See the
    > tools menu)
    >
    > Does that help?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  7. Peggy

    Peggy
    Expand Collapse
    Guest

    No, it is not, wish it was that easy tho! Thanks very much for your help,
    Tony!

    "Tony Toews" wrote:

    > Peggy <Peggy @discussions.microsoft.com> wrote:
    >
    > >I was working in my Access when all of a sudden a column disappeared. I went
    > >to a report and the info is missing off that page as well. How can I recover
    > >the lost column?

    >
    > Is the width of the column in the datasheet view set to zero?
    >
    > 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
    >
     
  8. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote:

    >>> I was working in my Access when all of a sudden a column
    >>> disappeared. I went to a report and the info is missing off that
    >>> page as well. How can I recover the lost column?

    >>
    >> Is the width of the column in the datasheet view set to zero?

    >
    > I should of thought of that. It that the voice of experience speaking?
    >:)


    Ayup.

    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