Saving sharepoint credentials in Access import VBA script

Posted on 2012-08-13
Last Modified: 2013-02-14
I have created a VBA script to automatically download sharepoint lists into my Access 2010 database, however, i want to be able to hardcode my user credentials into the script so that it doesn't prompt when trying to connect. I'm using the DoCmd.TransferSharePointList Method  to call the lists. Is there a secret switch or someway to save the credentials in there?
Question by:Forensicon
    1 Comment
    LVL 22

    Accepted Solution

    I'm afraid there isn't. Maybe you can create a setup where the Windows user is know by SharePoint, that way you don't need to supply the credentials.
    I think (for example) VB.Net can supply the credentials (although you need to use another method than TransferSharePointList of course). So you might be able to create some VB.Net code you can call from MS Access.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now