Forum Discussion
Strange/Lock Out From SharePoint
Have you tried the trouble-shooting steps and work around described here?
This problem seems to have more to do with SharePoint than Access. And, since the focus of this forum is MS Access, not SharePoint, you're more likely to get attention from specialists in SharePoint by re-posting in a SharePoint focused forum. Folks here tend to know Access pretty well, but not so much about SharePoint.
Accounts and passwords and different email addresses for SharePoint is something of a dark art, IMO, but to a SharePoint expert, it may be less obscure.
George_Hepworth I think it is narrowed down to the Linked Table Manager. From what I can see the Linked Table Manager is keeping a connection that I cant remove. Anyone know how to completely remove the link from Linked Table Manager?
That may be the problem, but from the original description, I am not sure it follows.
However, to be sure, you could try these steps.
- Create a new accdb.
- Import all objects from this one EXCEPT for the tables.
- Open the new accdb, holding down the shift key to by-pass any start up code.
- Relink the new accdb to the existing SharePoint Lists.
Does that resolve the problem?
This is the issue I am meaning.
If I try and open the Sharepoint Linked Manager loads the existing link. No matter what I do. I am assuming this is some existing link perhaps in registry and this is preventing the link being reestablished?
If I click through it will then ask for user name and we go dancing down a rabbit hole to the existing connection blah blah.
