Wednesday, August 18, 2010

Hiding Edit in Datasheet, Export to Spreadsheet and Open with Access Menu Items

To hide the Edit in Datasheet, Export to Spreadsheet and Open with Access menu items. Create a custom Permission Level using the directions found here.

When specifying the permissions for the custom Permission Level make sure Use Client Integration Features is unchecked, this will prevent users from launching client applications which includes Access embedded in the datasheet, as well as the external applications. Unchecking Use Remote Interfaces is probably a safe bet as well.

1 comment:

Jimbo Alba said...

I tried this but I still see the "Edit in Datasheet". It may not work always I guess.