task sch - timer vba modules (2 Viewers)

[idxyz]

hi,
My OS is Win 10 x64, and have an office 365 access database 16 program.
My bat file launches access program when invoked from inside a task sch.
Recently have noticed that when bat executed from task scheduler and Access is launched, the vba code in timer stops in the middle.
If I execute the bat file manually, it all works as normal as used to.

 

[Ranman256]

on that pc, it might be a protection issue.... set enable all macros:

set Trust center settings:
access menu:
File,
options,
trust center, (left pane)
trust center settings btn, (right pane)
Macro Settings,(left pane)
Enable all macros

 

[idxyz]

i did follow this, still the same, no change.

 

[The_Doc_Man]

Did you remember to identify the correct username under which to run the batch job? By default, something run by Windows Task Scheduler is not run as you but as SYSTEM. I could imagine a recent patch having an effect on stuff run as the wrong user.

To clarify - Ranman256 could be right in that it is a protection issue - but wrong about why.

 

[idxyz]

Did you remember to identify the correct username under which to run the batch job? By default, something run by Windows Task Scheduler is not run as you but as SYSTEM. I could imagine a recent patch having an effect on stuff run as the wrong user.

To clarify - Ranman256 could be right in that it is a protection issue - but wrong about why.

the sch task option that is checked on is "whether user is logged on or not". It acts the same whether I am logged in or not.
how do i make sure right user is running batch in any case?. Do i have to set the permission levels in security tab for the batch property?.

 

[The_Doc_Man]

It's been a while since I've played with this, but you should have a "Run As..." option that lets you pick the username. It will have that option unless it has finally been "fixed" to default to the username of the person requesting the schedule. Can't tell you how long ago it was since I've used it, but t the default wasn't the activating user when I first ran across this feature. Of course, I first used it before the advent of WinNT, and that's quite a while ago.

 

[Gasman]

the sch task option that is checked on is "whether user is logged on or not". It acts the same whether I am logged in or not.
how do i make sure right user is running batch in any case?. Do i have to set the permission levels in security tab for the batch property?.