I have some code which establishes a link to SharePoint:
This code works great, it creates the link to SharePoint as needed. However, I am not trying to run MS Access through Terminal Services. The problem there is that my Network ID credentials are no longer being passes to SharePoint, thusly the code breaks because SP needs a username and PW.
There seems to be something there which says RetrieveIds=Yes; and although it works fine from my desktop to SharePoint, it does not within Terminal Services.
Does anyone know how I can pass my User credentials programmatically (meaning to hard code that stuff and pass it through) to SharePoint?
Or is there any workaround that anyone might know?
Thanks,
Gary
Code:
'Establishes the SharePoint Link
DoCmd.TransferDatabase acLink, "WSS", _
"WSS;HDR=NO;IMEX=2;" & _
"DATABASE=http://sps.someplace.nih.gov;" & _
"LIST={4D444DD4-ABC7-489D-8B77-4F4D5E30B108};" & _
"VIEW=;RetrieveIds=Yes;TABLE=Repository", acTable, , _
"SLARepository"This code works great, it creates the link to SharePoint as needed. However, I am not trying to run MS Access through Terminal Services. The problem there is that my Network ID credentials are no longer being passes to SharePoint, thusly the code breaks because SP needs a username and PW.
There seems to be something there which says RetrieveIds=Yes; and although it works fine from my desktop to SharePoint, it does not within Terminal Services.
Does anyone know how I can pass my User credentials programmatically (meaning to hard code that stuff and pass it through) to SharePoint?
Or is there any workaround that anyone might know?
Thanks,
Gary
