Perhaps it's too simple, but if you know which tables are corrupt and you can view the data you can often fix them using queries.
For example, If you know that record #1652 is corrupt in "TblMyData" then run a "make table" query from that table with a condition on ID as <=1651 AND >=1653. That will create the table skipping the corrupt record.
Of course, if you have too many corrupt records this will be time consuming as you will have to run >= clauses multiple times (the second time you run the query it will be an "append query" not a make table query. I have used this when I had up to 30 corrupt records - and probably would for more as the data is very important to me.
All of this is useless if you don't know the source of your corruption, however.
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.