Is there any way to run an access database using the background execution context? We run a lot of reporting (generating pdf files) through access which runs fine using the foreground execution context.
Visual cron calls C:\Windows\System32\wscript.exe to execute a vb script which opens access.
The VB script is as follows:
dim fso, file_to_open, objAccess
Set fso = CreateObject("scripting.filesystemobject")
file_to_open = "Q:\Reports\xxxxxx.mdb"
As mentioned this works fine in the foreground, but we want to run in background as we don't want to need a user to be logged into the visual cron server at all times.
Do you have any suggestions? The VBS comes from using the windows task scheduler which is our current production process.