You may have to search for a good backup. I tried running a few of my 'special' repair utilities without success, including trying the /decompile switch, jetutil, and trying to import the tables into a new mdb.
I'm guessing somewhere along the lines, the backend mdb became corrupt and you've been backing up a corrupt mdb via your 'function'. I'm not sure what your function to do this looks like but I would recommend in the future you write a simple vb script to copy the backend mdb (when it's not open) or use some kind of backup software to backup the folder/mdb file on a nightly basis, especially if this was critical data. It's not a good idea to backup a backend mdb (while it's open via any linked tables) in your frontend as you've discovered (unfortunately, the hard way).
I have one other utility but I only use this on a pay for basis but I charge quite a lot for my time and don't like to advertise doing this on any help sites. You'd probably be better off sending the mdb to one of the repair mdb sites (google them). They 'might' be able to help since this mdb looks like it needs an advanced repair type utility (if it even is repairable.)
