Bama Breeze
07-21-2011, 08:59 AM
I have an MS Access 2007 database with a link to a SharePoint Issues list, which must be relinked frequently. I can relink it using the wizard (right-click on the table name, click SharePoint List Options, Relink Lists), but I would really like to automate it with VBA.
I'm trying to use this:
DoCmd.TransferSharePointList acLinkSharePointList, "https://website.com/PWA/2011%20Integration%20Testing", "XXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX", , "Issues"
Where the ListID is the segment of the list URL between "ShowWebPart={"and "}".
When I run that, I get this:
Run-time error '31559'
[Database Name] Report could not connect to the site you specified. Verify the address of the site or contact your site administrator.
Any ideas?
I'm trying to use this:
DoCmd.TransferSharePointList acLinkSharePointList, "https://website.com/PWA/2011%20Integration%20Testing", "XXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX", , "Issues"
Where the ListID is the segment of the list URL between "ShowWebPart={"and "}".
When I run that, I get this:
Run-time error '31559'
[Database Name] Report could not connect to the site you specified. Verify the address of the site or contact your site administrator.
Any ideas?