Greetings all ...
I can't seem to get around the failure to create an ACCDE file. I've run through the steps outlined in the above link's question 4 times, and feel I'm doing everything to the letter.
This is a huge conversion for a project I've had available for years, but only as a linked ACCDB FE/BE pairing. It's important enough that I be able to create these ACCDE files that I'm trying to make sure these larger functions will work before I invest another 30 or 40 hours in development time.
There are about 25 linked tables (no data, just structure), and 2 forms. I have a reference out to a Lib Db, existing in the same folder as the file I'm trying to convert. I'm trying to convert it into the same folder as the source ACCDB file.
The only thing I can think of that's weird is that I made the mistake of letting the wizards create the 5 command buttons on one of the forms, before realizing that it creates those little embedded macros. Each of my command buttons has ancillary behaviors built in, so I went in and "replaced" (I think ... I don't know how to delete these little macros) the Click event reference with a regular section of code in the class module. I've compiled, repaired, decompiled , recompiled, repaired, compiled, decompiled and repaired so many time now that I can't imagine there are still vestiges of those original little embedded macros, but what do I know?
All I know is that Access is throwing up the "Unable to create Accde" dialog box almost as fast as I select a location for the file, and I can't get beyond it. And I need to know if this whole conversion to an accde will be an unachievable goal before I get to much further.
I understand this question has been covered before, but let's just call this a "Hail Mary".
Many thanks in advance for any suggestions as to what I might look for (in addition what MX covered in the above link)