i find that most of the time when i can't compile to an accde file that there is an issue with broken references. I normally go to the references, deselect all of the additional ones, then reselect then and do a compact and repair and it will then let me compile the database.

hope that helps