Run-time Error '-2147024770 (8007007e)': Automation Error The Specified module could not be found vba

Question

I have an access application which runs just fine on one of the term server(remote server 1), but, when I run the same app on diff term server(reomte server 2) it gives me a message "Run-time Error '-2147024770 (8007007e)': Automation Error The Specified module could not be found ". Below please see for the screenshot, I am not able to figure out what is that thing which is missing from remote server 2 which is not letting me run the app in there. Unfortunately, I am not the admin in that server and I have limited visibility in there. 

Answer 1

sneet7 -

This site looks promising https://blog.pcrisk.com/windows/12626-how-to-fix-qthe-specified-module-could-not-be-foundq-error

I have not used, nor have I had to use, any of the methods described there, however. Caveat lector!

---

peter n roth - http://PNR1.com, Maybe some useful stuff

Answer 2

You're running the database directly on the server?  Normally the front-end is distributed to reach user and placed on their local PC and run there.

Regardless, the first thing is do is compile the database directly on the server to ensure everything is okay on that front and that all the references are valid.

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net