Results 1 to 1 of 1
  1. #1
    memaxt is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2013
    Posts
    13

    SharePointlist driving me crazy! Missing Columns

    Hi there,




    I'm beginning to to pull my hair out with this.


    My database that distribute to my team is failing to sync all columns on linked a SharePoint list


    I've added a button to the database to auto re link the SharePoint to resolve this issue:


    DoCmd.DeleteObject acTable, "tblPro"
    DoEvents


    DoCmd.TransferSharePointList _
    acLinkSharePointList, _
    "https://nhsengland-my.sharepoint.com/personal/blahblah/", _
    "{C4ZFF04B-5FE8-4C35-AAE7-2503FC532EC0}", _
    "{4254C6B8-2582-4AF5-9A93-39914A02E379}", _
    "tblPro", _
    True


    CurrentDb.TableDefs("tblPro").RefreshLink
    DoEvents




    Although this links the SharePointlist it does not sync all columns, e.g. only syncs 8 out 10 columns making the data not available.


    just to clarify the columns are not hidden.




    The only way to fix this is to re-link it manually which is a no no...is there anyway to force access to get all columns using a procedure?




    Many thanks
    Max
    Last edited by memaxt; 02-18-2016 at 09:38 AM. Reason: missing information

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

Similar Threads

  1. #Type! error driving me crazy!
    By N1755L in forum Forms
    Replies: 22
    Last Post: 05-06-2014, 03:22 PM
  2. Dlookup driving me crazy
    By NJMike64 in forum Modules
    Replies: 3
    Last Post: 04-19-2014, 01:58 PM
  3. Too few arguments is driving me crazy....
    By Spidee in forum Access
    Replies: 3
    Last Post: 07-10-2013, 07:41 AM
  4. I know it's easy but it's driving me crazy!!!
    By pensived in forum Queries
    Replies: 1
    Last Post: 02-22-2012, 02:55 AM
  5. ShipToCode is driving me crazy
    By Accessgrasshopper in forum Access
    Replies: 7
    Last Post: 02-26-2011, 04:55 PM

Tags for this Thread

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