I was promoted to site collecton administrator on a sharepoint. Now I cant use the button "open with access" anymore. Previously I was user with read-write and there was no problem with using access to edit my list.
i know you have used it before but we do make mistakes, just incase make sure your looking at site level and within a team site! also make sure you have Microsoft Access 2010 Runtime installed.
Ok just incase you can try it this way,
click on open file, you should get a new dialog popup. Within the dialog select the dropdown button to show you different file formats. For you click on microsoft sharepoint foundation:
now go through the wizard setup to make the link, copy past the list url to re-establish the connection:
you should have the connection backup in sharepoint!
I dont see why you would have the "connect to access" grayed out and same with viso, the only other thing that i could think of is if the access for site collection admin is in a group that has limmited access to external applications but i wouldnt see why they would do that?