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.

As before, any feedback would be great!