Get rid of "SAVE CHANGES Save your changes to the server. [Save to SharePoint Site]"-Yellow Banner

[jaeapla]

I use the switchboard form, so the easiest thing to do is to open the switchboard form in Design View (or whatever Form you automatically use when you open Access) and click on Property Sheet. Go to 'On Load' under Event tab and click the three dots[...]. Then insert the code below (make sure Private Sub and End Sub are not duplicated). Save the form and when you open the Access program the next time, the "SAVE CHANGES Save your changes to the server. [Save to SharePoint Site]" - Yellow Banner should be gone.



Code:

Private Sub Form_Load()
'This gets rid of the "SAVE CHANGES  Save your changes to the server. [Save to SharePoint Site]" yellow banner
   On Error Resume Next
   CurrentDb.Properties.Delete ("PublishURL")
End Sub

[davegri]

Good to know. This is rare but I have seen it a couple of times.
OP is talking about getting rid of this:



The provided code line can also be executed in the immediate window once. No need to execute at every DB opening.