I know... something silly...
1st try to open the DB file while holding the shift key down. So long as you haven't disabled this key yet you might be able to get into the DB still. I've had this happen and work.
I then moved everything out of that DB file into a new one!
2nd:
5.How to Decompile an Access Application Or How to do a Full Fresh Compile
3rd: (because you didn't state the version)
How to troubleshoot and to repair a damaged Access 2002 or later database which inculdes NeoPa's solution as well.
There are some shareware and payware tools out there that promise the moon (and proof of string theory); however, I'm a little leary of them as a whole in that the ads tend to be better than the results. However, many of them will get stuff when nothing else works... cost to data ratio needs to be considered.