I was updating an app launcher to use Microsoft Graph instead of legacy Sharepoint API login credentials for authentication. The transformation went very smoothly and I was able to use Microsoft CoPilot with ChatGPT-5 mode to handle a lot of the grunt work! It definitely saved me time in hunting down all the documentation of how Microsoft Graph worked. Shoot me a reply if you’re interested in hearing more about that.

Once this task was completed, I needed to create a 32 bit and 64 bit accde file for the deployment.

The 32-bit version of Access I used had no problems and created the accde file right away, but the 64-bit version just hung and Access crashed. The save as dialog box to choose the file name never even appeared. What devilry is this, I thought.

So some quick searching on the web about Access crashing during accde creation brought me to this article by Colin Riddington on his Isladogs web site: Why can’t I create an ACCDE file?

I don’t do a lot with accde files, but I do tout their benefits in many situations and prevent clients from modifying your VBA. But I digress. It turns out that the problem I was having (a crash, not an error message) was slightly different, but I did note that referencing (I assumed in the VBE Tools->References section) of 32 bit accdb or mdb files would cause the error.

I then spoke with my colleague (and dad) Steve Halder who had similar issues to me with accde creation and had solved this by disabling our standard development plugins. It seems that referencing an accda add in file can also cause an issue and that is why I was unable to generate the 64-bit accde file. Once I disabled my add-ins, I was then able to create the file. Whew, that was a weird one!