Solved

Automatic linking to Sharepoint list from access 2007 database

Posted on 2009-07-12
2
867 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
Comment Utility
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Outlook Free & Paid Tools
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

728 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

10 Experts available now in Live!

Get 1:1 Help Now