• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 998
  • Last Modified:

Hiding the "Open with Access" in sharepoint lists (SP2007)


I need to hide the "Open with Access" menu item under the "Actions" tab for sharepoint lists (we r using SP2007). I can create a custom permission level and remove the client integration features. But that makes the "Edit in Datasheet" functionality not work as it needs ms access to work with sharepoint. Edit in Datasheet is a showstopper. So I need to have the client integration feature turned ON for users, but I dont want them to see the "Open with Access" option. I need to hide it only for 1 list in a sharepoint site and not for others. Also I have access to only this site. So need help with a easier way to achieve this.


  • 3
  • 2
1 Solution
balurocksAuthor Commented:
Unfortunately, No. AllItems.aspx doesnt have the "open with access" (ExportToDatabase) attribute. Pls ccheck the last comment in the same blog page.
FYI - I verified this solution.

Add the below javascript via SharePoint Designer to your AllItems.aspx page (and other views).
 No Access No Access
<script language="JavaScript">
 var doc = document.getElementsByTagName('ie:menuitem'); 
 for (var i = 0; i < doc.length; i++)
    itm = doc[i];
    if (itm.id.match('ExportToDatabase')!=null)
      { itm.hidden=true; }

Open in new window

Regarding the last comment on the blog. I don't know what to say.

I provided proof it works.
balurocksAuthor Commented:
Thanks for example. That really helped. I tried searching for menu tags on the view pages.

"The trick here is to find the menu tags on the page. What we are looking for is this:

      <ie:menuitem id="zz23_OpenInExplorer" ... hidden= ... /> "

Infact I searched this across all view pages in the site and didnt see anything. So I didnt even try.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now