Results 1 to 7 of 7
  1. #1
    wselvo is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2021
    Posts
    4

    Problem with scheduler Windows Server 2016

    Hello, I have created a procedure in Access which, if done manually, works fine; if it is launched through the scheduler it starts and then stopped.
    I tried to put some message boxes but it doesn't reach them so it would appear to hang on startup.
    Versions: Access 2106 build 14131.20320 - Windows server 2016 Standard Vers. 1607 buid 14393.4530
    Any ideas?
    Thank you.

    Walter Selvo

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You may need to check the file location is able to have access started by the service account on the Server.
    When you open it it has your privileges, when the scheduler does it it depends which account is running it.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    wselvo is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2021
    Posts
    4
    Thank you for your answer. I have tried moving the folder in \public\documents but nothing change (I think that over this folder the scheduler account has privileges).
    I make something wrong?
    Thank you again.

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Try running the Scheduler as Admin ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    wselvo is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2021
    Posts
    4
    No with my user. It would be better use Admin?

  6. #6
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Well, If it works then at least we can assume it is probably a permissions issue.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    wselvo is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2021
    Posts
    4
    Ok, I can't now but as soon as I can I'll let you know. Thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-17-2018, 07:33 PM
  2. Windows Task Scheduler .Bat File Macro
    By mrmmickle1 in forum Access
    Replies: 26
    Last Post: 09-08-2015, 04:21 PM
  3. OnClick_Btn to Macro for Windows Scheduler
    By meg9222 in forum Macros
    Replies: 1
    Last Post: 08-09-2013, 01:42 PM
  4. Windows 7 scheduler
    By faeren in forum Misc
    Replies: 1
    Last Post: 01-27-2012, 10:26 AM
  5. Macro having issues when run on Windows Scheduler
    By faeren in forum Programming
    Replies: 4
    Last Post: 09-15-2011, 09:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums