This is an older article that was recycled for Fri, but still seems to get a decent number of views and some good discussion. It's fun to see who sees the power of Access and not just the pain! I still use Access for some really adhoc reporting and for one off data changes, just faster than SSMS in most cases. Not because the tool is faster, it just has a better UI.
The article is at http://www.sqlservercentral.com/articles/Access/linkingaccesstosqlserver/2176/.