Results 1 to 2 of 2
  1. #1
    SteveApa is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    84

    Access with Sharepoint lists linking & renaming and keeping relationships to userinfo

    Hi.

    Thanks for reading.

    I am creating an access db to link to multiple sharepoint lists on multiple sharepoint sites. I build the links in VB. I want to manage all of the lists thru access instead of going to each url to edit the data in the lists.



    I loop thru an sql server table to get the project numbers & urls of the lists... each project has it's own site / sharepoint lists. All of the different lists, on the different sharepoint sites, have the same names.. Risks & Issues & userinfo. Based on the project #, I link the lists and rename them (concatenating "_Risk" or "_Issue"). When I link the Risks list, userinfo automatically pops in as a linked list in access. I rename the Userinfo... that is where i think my problem is. I think that by renaming it, the 'lookups' in the risks and issues lists gets broken. If I try to open the userinfo list, sometimes it shows #deleted#.

    1) do I delete the userinfo table when it automatically gets linked by linking the risks list? Then manually link the userinfo list and rename it during the linking?
    2) how do I keep the lookups from teh risks / issues lists to the userinfo list?

    code to link tables based on looping thru project numbers / url associated. In the code below, I pass the new table name... example PRJ-00090111 is passed as PRJ-00090111_Risks & PRJ-00090111_Issues.

    Code:
    Public Sub Link_New_Issues_Risks_Tables(url As String, table_name As String)    
        DoCmd.TransferSharePointList acLinkSharePointList, url, "Risks", , table_name & "_Risks"
        DoCmd.Rename table_name & "_UserInfo", acTable, "UserInfo" ' userinfo list gets automatically linked after I link the risks list, so I rename it
        DoCmd.TransferSharePointList acLinkSharePointList, url, "Issues", , table_name & "_Issues"
        
    End Sub
    Thanks.
    Steve

  2. #2
    SteveApa is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    84
    I just did a little test... userinfo data is #deleted# even before I rename it. It must be renameing the 1st table (risks) that causes the issue??

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA To Import SharePoint Lists Into Access 2016
    By chalupabatman in forum Modules
    Replies: 6
    Last Post: 01-06-2019, 04:35 PM
  2. Linking Access to Internet without SharePoint?
    By McArthurGDM in forum Access
    Replies: 6
    Last Post: 08-07-2015, 02:29 PM
  3. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  4. Replies: 1
    Last Post: 08-22-2012, 05:27 PM
  5. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums