Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Bad record freezes table
- Thread starter Dan01
- Start date
If the table can not be opened because of a corrupted record it cannot be copied. Make sure this can not be repaired by repairing the database. If it can't, create a maketable query using your bad table adding all the records. You will find Access unable to copy your corrupted record giving you a perfect copy of your table. Delete the bad copy keep the good one renaming it. If relational restraints prevent this make a new database shell and import all tables and relationships, same principles will hold, you will end up with a copy of the whole database minus the corrupted record. Use the corrupt record to help you remove it and don't fight it.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
