Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2001
    Location
    LA, California, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    bizarre ###### records

    I somehow ended up with 90 something records in a table where most of the fields were ############, and it wasn't because the display width was too narrow. I couldn't see any numbers in my autonumber/primary key field, but there must have been something since I deleted the records without a problem. (Getting rid of corrupted records missing their primary key is not that easy.) However, when I sorted the table by the autonumber field the messed up records appeared before record #1. Anyone ever seen this before? Any clue what would cause that? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  2. #2
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bizarre ###### records

    Haven't seen it with an autonumber field (if I understand you correctly), but I have seen it when importing from Excel when the source field was too narrow... "Fix" was simply delete the records, go back to the Excel worksheet, increase the width, and reimport.

    Why this problem/fix? Go as Microsoft, cos I don't have a clue!

    Kiwi44

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bizarre ###### records

    This is a common symptom of a corrupt Memo field, generally happens in individual records when corrputed due to incorrect shutdown or network problems. If it's happening in a number of records it sounds more serious. You may try compact and repair.

  4. #4
    Lounger
    Join Date
    Mar 2001
    Location
    LA, California, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bizarre ###### records

    It may have been a network problem or something of the sort. I found out from one of the users that someone was having trouble when they tried to create a new record. He tried to help, but Access would not let him get cancel the new record in any of the normal ways, and ####### kept appearing in different fields. I didn't import anything from Excel recently, so that wouldn't have been it.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •