I've thought this over and changed my mind since question 2 seems distinctly different. My other Front End, not just a copy, but an entirely different form, queries, reports and modules will not compile.
"Microsoft Access was unable to create the .accde, .mde or .ade file."
Help gives me a warning about creating too many tables, forms, reports and/or modules, but that is not my problem. There are less than 100 altogether. This Front End is similar to the other in that it is also primarily macro driven. I've encountered this before when my code put some reports into design mode and changed the record Source, but that is not happening here. There are two forms and two modules and I have touched only a small portion of it. This is the same problem the back end is having. The Back End is similarly straightforward. There is very little to it, a single form, a couple command buttons and a couple modules. Tips and a shove in the right direction would be appreciated. Let me know if you have any questions.