Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: Corrupted Database

    Hi There!
    I have a problem with an access database (XP), someone turned off the computer while working on it and got corrupted.
    I have been able to find the record that is causing the problem but I can't delete it!, I can delete any of the records on the table but that one.
    When I try to delete it I got the following message: "The search key was not found in any record" and when I try to export it Access crashes just before it gets to that record.
    I've tried the compact and repair option but access always crashes in the process.
    I've also tried 4 different computers, with no luck.
    Has anybody had this problem before?
    Thanks in advance for your responses.

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Try the repairer that Microsoft provides:
    http://support.microsoft.com/default...;EN-US;q295334

    There are also a number of commercial utilities which are excellent at recovering corrupted databases. I'll find those links and get back to ya.

    (Try http://www.officerecovery.com/access/demo.htm or maybe http://buyonline.ontrack.com/ecom/catalog.asp )

    Cheers,
    Andrew
    Last edited by Bunce; 07-14-02 at 06:58.
    There have been many posts made throughout the world.
    This was one of them.

  3. #3
    Join Date
    Apr 2002
    Location
    UK
    Posts
    1
    Try creating a new database and importing all other tables, forms,modules etc into this.

    Then use the import function to import just the structure of the troublesome table.

    Go to the corrupt database, open the corrupted table, select from the first record to the record just before the corrupt record and use 'cut and paste' to transfer these records into the new database table.

    Then go past the corrupt record and select all the records to the end of the table and 'cut and paste' these remaining records into the new table.

    All you need to do then is to wave 'bye-bye' to the corrupt database.

    Worth a try - good luck!!

  4. #4
    Join Date
    Oct 2002
    Posts
    3

    Thumbs up Thanks a lot!

    Originally posted by Bunce
    Try the repairer that Microsoft provides:
    http://support.microsoft.com/default...;EN-US;q295334

    There are also a number of commercial utilities which are excellent at recovering corrupted databases. I'll find those links and get back to ya.

    (Try http://www.officerecovery.com/access/demo.htm or maybe http://buyonline.ontrack.com/ecom/catalog.asp )

    Cheers,
    Andrew
    I had a problem with a Microsoft Access database and I used the repairer from Microsoft and I was able to fix the database. Thanks a lot!

Posting Permissions

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