Prevent "Save to SharePoint Site" alert in Access 2010

Question

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?

Answer 1

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.

Answer 2

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.

Cheers!