For the longest time, I could not make a accde file of my FE database. I went through all the troubleshooting Richard gave me. After much trial and errors, I realized, if there is any VBA code that is not right, it does not make an Accde file.

Deleted all the wrong ones and compiled it,.now I am a proud owner of 5 FE files that I hv given my employees and a huge relief that our DB is running faster.

Just wanted to share it with anyone who has the same issue as me.