Solved

Automatic linking to Sharepoint list from access 2007 database

Posted on 2009-07-12
2
879 Views
Last Modified: 2012-08-14
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.
 
http://www.screencast.com/t/vpwDObl2
 
 
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

0
Comment
Question by:phoenxMan
2 Comments
 
LVL 13

Accepted Solution

by:
Surone1 earned 500 total points
ID: 24839974
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
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…

679 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