Results 1 to 5 of 5
  1. #1
    koper is offline Novice
    Windows XP Access 2000
    Join Date
    Dec 2008
    Location
    Arizona
    Posts
    13

    Cannot Delete a Record "# Deleted" in ALl Fields

    I have an autonumber field that says "3491" but when I sort on that field it sorts as "3474." This means that a form that uses this field to bring in data through a relationship is the wrong field. I have tried to unsuccessfully delete the entire record. It asks if I am sure I want to delete the record and I say "yes" but the record remains and now all of the fields say "#deleted" and I cannot open any queries that sort using this field. (I get the error "No Record".) I have tried to fix this with "repair database."

    How can I delete this obviously corrupted record?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Have you already run JetComp on the db? How big is the db? Could you zip it and post it?

  3. #3
    koper is offline Novice
    Windows XP Access 2000
    Join Date
    Dec 2008
    Location
    Arizona
    Posts
    13

    Fixed

    I tried the Jetcomp utility and it worked like a charm. Thanks!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Excellent! That's what I like to hear. Are you ready to use the Solved thread toll yet?

  5. #5
    koper is offline Novice
    Windows XP Access 2000
    Join Date
    Dec 2008
    Location
    Arizona
    Posts
    13
    I fixed it by running the Jet Comp Utility. Thanks!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  2. Error "Record is Deleted"
    By koper in forum Access
    Replies: 8
    Last Post: 03-10-2009, 10:20 AM
  3. Link tables on "special" fields
    By Gargen in forum Access
    Replies: 0
    Last Post: 12-18-2008, 12:02 PM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums