Forum Discussion
GoodLookingFella
Jul 09, 2021Copper Contributor
Strange/Lock Out From SharePoint
I have been making databases a while and been helping my cousin on the other side of the country out via an Access front end linked to a SharePoint backend. Its been working fine for about a year or...
- Jul 12, 2021
Have you tried the trouble-shooting steps and work around described here?
George_Hepworth
Jul 11, 2021Silver Contributor
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?
GoodLookingFella
Jul 11, 2021Copper Contributor
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.
- George_HepworthJul 11, 2021Silver Contributor
Thank you for clarifying the specific circumstances.
What happens if you go through this option:
- GoodLookingFellaJul 11, 2021Copper ContributorSame ring a rosy
- George_HepworthJul 12, 2021Silver ContributorI forgot; did you create a new accdb and try to link to the SP lists from it?