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

Automatic linking to Sharepoint list from access 2007 database

I have a simple Access 2007 frontend linked to and synchronize connections. User opens the access database, works on data off line, then re-links or synchronizes the databases changes back to sharepoint list.  I can automate the connection using docmd.transfersharepointlist command but it still prompts for the password and the login the first time it runs.  

How can I pass the login and the password to the connection request from the event procedure? How can I detect the object that prompts for the name and send key to the okay button, or bypass the need to enter manually the Username or the password. This to be passed as coded into the event procedure
see this short screencast video for visual demonstration of the problem.
The Code sample 
Private Sub cbnTestLinkingList_Click()
    'link or relink table to application
    Application.DoCmd.TransferSharePointList acLinkSharePointList, _
    "http://adzzoo.sharepointsite.net/Campaigns", _
    "Adzzoo Contacts"
    'how to pass the login and the password automatically to the connection request?
End Sub

Open in new window

1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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