Forum Discussion

GoodLookingFella's avatar
GoodLookingFella
Copper Contributor
Jul 09, 2021

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...
access
developer
office 365
sharepoint
GoodLookingFella's avatar
GoodLookingFella
Copper Contributor
Jul 12, 2021

George_Hepworth Thanks. I won't have time to look at this possibility till this time tomorrow, unfortunately.

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Jul 14, 2021

    GoodLookingFella 

     

    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
        db.Properties.Delete ("PublishURL")
        RemoveSPPublish = True

     

    End Function

     

    It is something of a long shot because I think you actually have a different problem, but it's worth trying.

     

Resources