Link to home
Start Free TrialLog in
Avatar of bcreen
bcreenFlag for United States of America

asked on

MS Access Run-time error '-2147024770 (8007007e)' : Automation error

this code generates the automation error: "The specified module could not be found.", but only on our Windows Terminal Server.  Folks running same MDB from the file server, do NOT get this error.
Dim fs as Object
Set fs=CreateObject("scripting.FilesSystemObject")
From previous solutions, I tried to drop SCRUN.DLL onto C:\WINDOWS\SYSTEM32\REGSRV32.EXE, but doing so failed with a return code of 0x80004005
Any additional suggested solutions appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
bcreen,jimhorn,

<Not sure what you mean by 'drop SCRUN.DLL ONTO...'>

Do you mean you tried to "Register" the DLL?

The syntax is:
REGSVR32 FullPathAndFullNameOfYourDLLFile

For example, something like this:
REGSVR32 c:\Utilities\SCRUN.DLL

(Don't know if it will help with your problem though?)

JeffCoachman

REGSVR32 "FullPathAndFullNameOfYourDLLFile" ;-)