I have some code that works for other folks but not for the SharePoint site I am trying to connect to. When I ran my code on my SharePoint, I am unable to find the List object. I thought at first that List didn't have the correct permissions but it turns out that it does. My current best guess is that I need to include password & ID parameters (the strConnection is correct).
cnn.Open ConnectionString:=strConnection, UserID:="MyUserName", Password:="MyPassword"
However, when I do so, I am now getting this error message:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Since this is a secured DB, I think this means I need to point the registry key to the full working group pathway but I am not sure how to do so.