Forum Discussion
Solved
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...
Have you tried the trouble-shooting steps and work around described here?
Yes I tried that, and had the same result. As I said it seems to me I need to be able to delete the old connection completely from the Linked Table manager and start again. However, I cannot, so far, discover how this can be done.
Have you tried the trouble-shooting steps and work around described here?
- I'm happy to hear you solved the problem, but embarrassed it took me so long to finally recall that little trick.
- This worked on the second try. For some reason, Access had a secondary account signed in. I am unclear why. My main account was mine, however, when I signed out there were my cousins name as an account, although it was yellow flagged !. I am unclear what happened...what I do know is after clearing the secondary connection it allowed me to relog in and the data is now visible.
Thanks for the patience, and I sincerely appreciate the help. 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 BooleanDim db AS DAO.Database
Set db = CurrentDB
RemoveSPPublish = False
db.Properties.Delete ("PublishURL")
RemoveSPPublish = TrueEnd Function
It is something of a long shot because I think you actually have a different problem, but it's worth trying.
George_Hepworth Thanks. I won't have time to look at this possibility till this time tomorrow, unfortunately.
