ok my issue is fixed!! What I had to do was to make a change to the form, in any fashion, compile the code, then create the accde file. Found an article online from 2005 explaining this and it also works with 2007 version.
I had also tried to resolve by opening the original DB, compile the...