Windows Script Host Error You Made An Illegal Function

[aellistechsupport]

I have looked and tried so many things and I cannot figure this out at all.

I have a module that is ran from a macro via a .vbs file which Windows Task Scheduler launches to run.

It works great from my work station. I moved it to the server, it's intermittent.
it worked once here and there but will not run on the scheduled time.

Had to change the option to run whether a user is logged on or not. found info on that and made changes per findings, still same issue.



If I run it the Macro directly from Access it. When I try to run the AutoRun.vbs I get the same error message.

I don't know what or how it ran under the When User is Logged On, but that won't work after the error comes up trying it with the new task to run whether or not user is logged on. We don't want to rely on someone being logged onto work.

Anyone else using Task Scheduler to run a VB Macro from Access and come across this issue? Have you found a solution that consistently work?

[HiTechCoach]

Yes, I do it successult with any user logged on. I use schedule a .cmd file not a VBS.

Since I don't have a clue what your AutoRun.vbs does , I an unable to help you debug it.

[aellistechsupport]

This is my AutoRun.vbs

dim accessApp
set accessApp = createObject("Access.Application")
 
accessApp.OpenCurrentDataBase("\\File02\usfs\Crystal and Excel Reports - Phoenix\CrystalReports\Memberships\MembershipsReporting.accdb")

accessApp.Run "ExportRptsMacro"
accessApp.Quit
set accessApp = nothing

I did have this bat file AutoRun.bat but it didn't work and why the above is used. And it works EXCEPT on the Server with the intermittent issues.

C:\Windows\System32\cscript.exe "\\File02\usfs\Crystal and Excel Reports - Phoenix\CrystalReports\Memberships\Scripts\AutoRun.vbs"

Also this AutoProcess.bat using the old /x macroname

C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE 
\\File02\usfs\Crystal and Excel Reports - Phoenix\CrystalReports\Memberships\Memberships.accdb /x ExportRpts