• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

Saving sharepoint credentials in Access import VBA script

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?
Yaniv Schiff
Yaniv Schiff
1 Solution
Nico BontenbalCommented:
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now