After creating an ACCDE file from ACCDB, several events are throwing up errors – although they continue to work flawlessly in the ACCDB file. For example, in the ACCDB file – a user has clicked the” Login” button after entering username and password. The OnClick event hashes the text password to generate a SHA256 string, which is then compared with stored hashes to authenticate the user. The ACCDB file uses the Microsoft Scripting Runtime (“C:WindowsSysWOW64scrrun.dll”) to generate the hash. Look at the function below and its output in the Immediate Window.

enter image description here

However, the same event in the ACCDE file throws an error. Look at the error below (“… problem occurred while communicating with OLE Server …”)

enter image description here

Once the Hash function is bypassed, the ACCDE code works normally.

I have tried decompiling/ recompiling multiple times. I have also removed all references and added them again before recompiling. But the error persists.

Can somebody explain why is this happening and how to overcome this issue?