Here is why: I have a SP2010 list with permissions set so that default is 'view only' and a limited group has 'contribute' perms.
If I log in with a non-priviledged account, and view the list,there is no 'Edit List' option available in the Ribbon as desired. But, in the Ribbon, there is Connect & Export > Open with Access. If I do this, I then find I have full CRUD rights and can wreak havoc on the list while within Access, and the changes do affect the list.
If I log in as an admin, and check permissions on the list for that non-priviledged account, I get back 'View Only'. In Site Settings > Site Admin > Site libraries & lists > (list) > Advanced Settings, the list is set to "Create & Edit Access : None". So from what I can tell, I've got things locked down as intended. Which leads me to believe that Access access full-CRUD-rights is a product bug or, far more likely, I'm missing something obvious. I figure if it's a bug it'll never get fixed soon, but if I can disable that "Open with Access" option in that Ribbon, that'll work.
Is there a way to disable that 'Open with Access' option in the Ribbon?
(Update a couple hours later) I can use CSS rules to hide the items in the ribbon, but to be sure that really isn't much of a solution. Ref. http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/bc921475-504d-4443-9388-828373e2582d