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.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.