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.
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.