Forum Discussion
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 so.
Last week I was asked to add some additional tables and then merge the data into the original SharePoint. I thought I would download the existing data/Tables from SharePoint work locally to test and create the work then upload the new tables when complete and transfer the front end to her.
Good plan...Until...I realised I hadnt needed to log in so long I forgot my password to her SharePoint. No problem I had that reset and thought yahoo...off I go.
Oh no. Now I am getting a very handy pop up that asks for my email address for accessing the SharePoint site, and then on inputting it, it tells me I cant go in as
No idea what to do from here. Any suggestions please?
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?
