Microsoft Access Recovery

If you find yourself in the scary situation of a corrupt Access file like a Kansas City client did recently,  here is a link to a great step by step resource for recovery.

Beyond the classic compact/repair and decompile/recompile there are a number of other steps (and sequence often matters) that you can employ to recover corrupt Access files.  If those steps don’t work there are a couple of other tricks including the Hail Mary of SaveAsText/LoadAsText *undocumented* technique.

If you find yourself facing this situation, once you have recovered, take a deep breath and then consider steps to prevent getting back in this predicament!