As you all know, you can't replicate, or repair/compact a database that has a corrupt field in it. Even if you delete that particular record the indexes are all messed up and you still can't repair/comact it. Usually the only solution is to recreate the table and move everything over to a new Access shell piece by piece. This is a pain in the ass. I've built a program for it. It's a module that you can pop into the modules tab of the corrupted database and run.
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
Access 97 - Recreate Corrupt Database
Reply With Quote
