<div>
<div class="content wysiwyg-content">
I am able to link lists in SharePoint to MS Access programmatically with VBA. Extract of the code as follows: <br />

<div class="indent">
Dim GUID, AccountChoice As String<br />
ListChoice = [ &nbsp; &nbsp; &nbsp; ] &nbsp; &nbsp;' the VBA code can grab the ListChoice<br />
GUID &nbsp;= [ &nbsp; &nbsp; &nbsp; ] &nbsp; ‘ the VBA code can grab the GUID<br />
<br />
DoCmd.TransferDatabase acLink, &quot;WSS&quot;, &quot;WSS;HDR=NO;IMEX=2;DATABAS<wbr />E=serverna<wbr />me/;LIST=&quot;<wbr /> &amp;&nbsp;GUID &amp;&nbsp;&quot;;VIEW=;RetrieveIds=Yes;TA<wbr />BLE=&quot; &amp;&nbsp;ListChoice, acTable, , ListChoice
</div>
Assuming 5 lists have been created in SharePoint and linked to MS Access ( i.e. &nbsp;List1, List2, List3, List4 and List5 ). Somewhere down the road, List5 is deleted in SharePoint and is re-created with the same name ( but now with a new GUID ). <br />
<br />
In the MS Access DB, the linked table, List5 – the link would have been broken as it was pointing to a GUID that has been deleted. <br />
<br />
My questions: How can I programmatically ( using VBA &nbsp;in MS Access) <br />
1. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;test in the case of List5, whether the link is broken ( or its equivalent ),<br />
2. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;And if the link is broken, &nbsp;how to delete the linked table, &nbsp;List5 in the MS Access DB. &nbsp; <br />
<br />
<br />
Thank you in advance for your assistance.
</div>
</div>


I am able to link lists in SharePoint to MS Access programmatically with VBA. Extract of the code as follows: 
Dim GUID, AccountChoice As String
ListChoice = [       ]    ' the VBA code can grab the ListChoice
GUID  = [       ]   ‘ the VBA code can grab the GUID

DoCmd.TransferDatabase acLink, "WSS", "WSS;HDR=NO;IMEX=2;DATABASE=servername/;LIST=" & GUID & ";VIEW=;RetrieveIds=Yes;TABLE=" & ListChoice, acTable, , ListChoice
Assuming 5 lists have been created in SharePoint and linked to MS Access ( i.e.  List1, List2, List3, List4 and List5 ). Somewhere down the road, List5 is deleted in SharePoint and is re-created with the same name ( but now with a new GUID ). 

In the MS Access DB, the linked table, List5 – the link would have been broken as it was pointing to a GUID that has been deleted. 

My questions: How can I programmatically ( using VBA  in MS Access) 
1.	test in the case of List5, whether the link is broken ( or its equivalent ),
2.	And if the link is broken,  how to delete the linked table,  List5 in the MS Access DB.   


Thank you in advance for your assistance.

MS Access Linked Table to SharePoint - Broken Link

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.