Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search key not found in any record (Access 2000)

    Two users claim they hit the same record at the same time in an Access 2000 application that I designed. The record is now corrupt and I cannot edit the record or delete it. When I try to edit this record or delete it, I get the message: "The search key was not found in any record." Although as I tab through and edit fields in the record it appears that changes are being accepted, at some point I get the above message and the only way out is to close the table without the changes being saved. Any suggestions would be appreciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search key not found in any record (Access 2000)

    I had once such a problem with a corrupted record.
    The only way I was able to get rid of it was importing in a new table all the records where the ID was less then the ID of the corrupted record and all the record where the ID was greater then the ID of the corrupted record.
    Then I recreate the corrupted record.
    Deleting the old table and rename the new and eventually recreate relationship.
    Do this on a copy of the db.
    May be not elegant but it works for me.
    Francois

Posting Permissions

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