Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Automatic linking to Sharepoint list from access 2007 database

Posted on 2009-07-12
2
Medium Priority
?
904 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 2000 total points
ID: 24839974
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

963 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