Share via

How to disable the 'Read Only' notification on an Access document when it is opened from within a document library (SP 2010)

Question

Thursday, December 12, 2013 2:37 PM | 1 vote

Hello, 

OK, so I am currently having issues with opening MS Access documents from SP 2010. I have taken an existing database and uploaded it into a document library. Now, when I open this document I get the prompt to open it in either 'Read Only' or 'Edit'. 

When I select 'Read Only' I can view the document, however I get the 'Read Only - Save As' notification when the document opens up. I have configured the document both from the source (on the original file) and from within SP to disable notifications - (from within the Trusted Options selection) 

Deleted the document and uploaded it again, and the 'yellow bar' notification is still appearing. 

I want to disable the 'Save As' function, or even hide this when the document is opened. Is this at all possible?? 

All replies (3)

Friday, December 13, 2013 5:41 AM ✅Answered

Hi Terry,

According to your description, my understanding is that you don’t want the yollow bar notification to display when you open Access documents.

This issue seems to be about the client application. Please compare the followings with the things that you did:
 1.Open the documents
 2.Click File->Options->Trust Center->Trust Center Settings
 3.Click Protected View, unselect ‘Enable Protected View for originating from the Internet’
 4.Click Message Bar, select ‘Never show information about blocked content’
 5.Click Macro Settings, select ‘Disable all macros without notification’

In addition, as this issue is about Office, I commend you create a new thread in Office forum, more experts will assist you with this issue.
Office forum:
http://social.technet.microsoft.com/Forums/en-US/home?category=officeitpro

I hope this helps.

Thanks,

Wendy

Wendy Li
TechNet Community Support

Friday, December 13, 2013 8:05 AM ✅Answered

When you open a file from SharePoint, a copy is created locally. In some cases the local copy is not cleaned up and can cause the problem you are getting.

Here is a post from someone with the same error, there are a couple of suggestions towards the end: http://www.eggheadcafe.com/software/aspnet/29196156/files-opening-in-readonl.aspx

In Sharepoint 2010 where users with contribute permissions when they try to open a document it always open in read only mode. I reviewed the farm configuration and everything seems to be fine. I also noticed that users with office 2013 are able to open and edit the documents with no issues. I knew at that point that it was related to the client office version and not Sharepoint. After a lot of research I found the solution.

  • On the client computer experiencing the issue click on "RUN" then type "RegEdit".
  • go to this path HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Common\Internet
  • Right click and create new "DWORD" entry and give it a name of "FSSHTTPOff"
  • Double click the new entry and enter 1 for the value.

Once done you might need to reboot the computer but not always required. once done the user with office 2010 will be able to edit documents in Sharepoint.

Please note that to apply this change to all users, your IT Admin will have to push out this change as a policy change on the network.

Friday, May 2, 2014 8:32 PM

1.Open the documents
 2.Click File->Options->Trust Center->Trust Center Settings
 3.Click Protected View, unselect ‘Enable Protected View for originating from the Internet’
 4.Click Message Bar, select ‘Never show information about blocked content’
 5.Click Macro Settings, select ‘Disable all macros without notification’