Solved

Automatic linking to Sharepoint list from access 2007 database

Posted on 2009-07-12
2
884 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Surone1 earned 500 total points
ID: 24839974
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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.

752 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