Jul 09 2021 03:39 PM
Jul 09 2021 03:39 PM
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?
Jul 10 2021 07:16 AM
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.
Jul 11 2021 02:30 PM
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.
Does that resolve the problem?
Jul 11 2021 02:34 PM
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.
Jul 12 2021 01:13 PM
Jul 12 2021 01:47 PMSolution
Have you tried the trouble-shooting steps and work around described here?
Jul 14 2021 06:48 AM
Well, if this works, it is truly embarrassing. I had COMPLETELY forgotten about this little code snippet and, more importantly, why I have it. My apologies.
This code was written back around 2010 when MS was trying to develop Access Web Databases, which used SP tables as the back end. That approach was deprecated. However, I wonder if this can help you here.
Public Function RemoveSPPublish() As Boolean
Dim db AS DAO.Database
Set db = CurrentDB
RemoveSPPublish = False
RemoveSPPublish = True
It is something of a long shot because I think you actually have a different problem, but it's worth trying.
Jul 14 2021 02:05 PM
Jul 15 2021 06:56 AM