Welcome to SPN

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

Sign Up Now!

Corrupted Records?

Discussion in 'Information Technology' started by Paul Fenton, Nov 18, 2005.

  1. Paul Fenton

    Paul Fenton
    Expand Collapse
    Guest

    We have a front end/back end application (Access 2k) which contains a
    table of client sales records, including date of sale and amount of
    sale. We run various sales reports off this table.

    While running the report for October '05 sales, we noticed that it
    would hang on "formatting page..." until we did a CTRL-BREAK. We've
    discovered that anytime we include the date of October 8th, the report
    will fail. There are 2 records that have a sale date of Octiber 8th.
    I can run the report from 10/1 to 10/7 or 10/9 to 10/31, no problem.

    We've compacted and repaired with no success. The records don't look
    any different than many others.

    Suggestions?


    Paul Fenton
    pfenton@plgassociates.com
     
  2. Loading...

    Similar Threads Forum Date
    Opinion How Could Punjab Police be Corrupted Then ? Punjab, Punjabi, Punjabiyat Dec 18, 2010
    Sikh News UK Sikh Harnaam Kaur Enters Guinness Records As Youngest Female With Beard - The Indian Express Breaking News Sep 9, 2016
    USA Robbery suspect seeks his NSA records Breaking News Jun 13, 2013
    Guinness World Records Refuses to Recognize Fauja Singh’s 'Marathon' Feat Sikh Personalities Oct 25, 2011
    Opinion Fauja Singh, 100 years old, Sets 8 World Records in Toronto Breaking News Oct 15, 2011

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    There might be some non-displayed characters. Try copying the raw data and
    Paste Special - Values in Excel. Then copy and paste back in Access.

    "Paul Fenton" wrote:

    > We have a front end/back end application (Access 2k) which contains a
    > table of client sales records, including date of sale and amount of
    > sale. We run various sales reports off this table.
    >
    > While running the report for October '05 sales, we noticed that it
    > would hang on "formatting page..." until we did a CTRL-BREAK. We've
    > discovered that anytime we include the date of October 8th, the report
    > will fail. There are 2 records that have a sale date of Octiber 8th.
    > I can run the report from 10/1 to 10/7 or 10/9 to 10/31, no problem.
    >
    > We've compacted and repaired with no success. The records don't look
    > any different than many others.
    >
    > Suggestions?
    >
    >
    > Paul Fenton
    > pfenton@plgassociates.com
    >
     
  4. Paul Fenton

    Paul Fenton
    Expand Collapse
    Guest

    One of the fields in the record is a Memo field. I discovered that if
    I delete all the text in those fields, the problem goes away and the
    report prints. I copied and pasted the text into Word and don't see
    anything unusual about it. It's 1500 characters or so.


    Paul Fenton



    On Thu, 17 Nov 2005 13:06:02 -0800, "KARL DEWEY"
    <KARLDEWEY@discussions.microsoft.com> wrote:

    >There might be some non-displayed characters. Try copying the raw data and
    >Paste Special - Values in Excel. Then copy and paste back in Access.
    >
    >"Paul Fenton" wrote:
    >
    >> We have a front end/back end application (Access 2k) which contains a
    >> table of client sales records, including date of sale and amount of
    >> sale. We run various sales reports off this table.
    >>
    >> While running the report for October '05 sales, we noticed that it
    >> would hang on "formatting page..." until we did a CTRL-BREAK. We've
    >> discovered that anytime we include the date of October 8th, the report
    >> will fail. There are 2 records that have a sale date of Octiber 8th.
    >> I can run the report from 10/1 to 10/7 or 10/9 to 10/31, no problem.
    >>
    >> We've compacted and repaired with no success. The records don't look
    >> any different than many others.
    >>
    >> Suggestions?
    >>
    >>
    >> Paul Fenton
    >> pfenton@plgassociates.com
    >>
     

Share This Page