Results 1 to 3 of 3
  1. #1
    qhs is offline Novice
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    1

    Access 2013 prompts for credentials when connecting to SharePoint 2013 list (can't automate)

    Hello,

    I have an accdb running on Windows Server 2012 R2, MS Access 2013, and linking to a table in SharePoint 2013. If I run a procedure manually it prompts for credentials and runs successfully. If I try to automate it with task scheduler (with admin permissions, etc), it will not run. I have UAC turned all the way down. Is there an access settings or OS setting that might be configured to prevent this?



    Thanks

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    How are you using Scheduler to run the procedure? Are you using Scheduler to open the accdb file? The issue is probably around security. There are different Administrators and I belive the solution is to add one of the Task Scheduler Admins to the Owner of the folder and the Access file. However, the simplest seems to be to have Scheduler open a VBScript file and have the script file open the accdb. What I do is, at the last minute, copy a premade script file into its final home while I am creating the Task. When I am creating the Task, I should be logged in with the correct privileges to run the script file I just copied and pasted.

    Here is some sample code to create the script.
    https://www.accessforums.net/access/...tml#post223969

  3. #3
    dave.stuart is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    7
    You need to set the credentials with the same account that you used when prompted by clicking the "Change User or Group Button". Also check the Run with highest privilages checkbox at the bottom.

    Hope this helps.
    Dave

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

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2015, 05:24 AM
  2. Access (2013) database in Sharepoint (2007)
    By Yellowboat in forum SharePoint
    Replies: 1
    Last Post: 01-28-2014, 04:58 PM
  3. Replies: 1
    Last Post: 12-26-2013, 09:41 AM
  4. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  5. Access 2013 Web App with Sharepoint 2013
    By miguel.escobar in forum Access
    Replies: 7
    Last Post: 06-17-2013, 09:03 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