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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.