Unable to Relink SharePoint Table with VBA

[TMSBrad]

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 Integration Testing",

"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?