We are storing an Access 2010 file in a SharePoint 2010 library and the yellow alert bar that says "Save to SharePoint Site" is showing up whenever users open the Access file. If the user closes the alert, the Access database/form no longer works properly for the user. The Access database is tied to a SQL Server backend where the data is stored. Access is only acting as an interface for interacting with the data.

Does anyone know why the alert shows up and how to prevent it from showing up without affecting the database functionality?

2 Answers 2

  1. Add the SharePoint site to IE trusted site as IE options->Security- >Trusted Site-> Sites. 2.Enable client integration-In SharePoint Central Administration site, click Application Management->Manage Web Applications, select the web application for the site. Click Authentication Providers, select default zone, and select Yes for "Enable Client Integration?"

give it a try.

  • Brilliant solution, but don't have access to our browser settings and Central Admin. I'll have to let my users know this is a side-effect of the way our browser and web app is configured.
    – CountZero
    Commented Sep 24, 2015 at 17:36

If you do not have a SharePoint site and use Access locally, here's a solution: Go to VBA window and type

CurrentDb.Properties.Delete "PublishURL"

on Immediate Window and hit enter, Close que database, reopen it and watch this file never ever again display this annoying message.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.