For several releases, Access and SharePoint have grown together, providing increasingly more compelling functionality – from fairly simple data sources through to web databases that run in a browser. Ben Clothier at http://accessexperts.net has a two-part review of the evolution of Access working with SharePoint. Part one is an overview of the Access/SharePoint integration. Part 2 is an in-depth look at Access data storage in SharePoint.
As you might expect, Microsoft itself has many resources to help with combining SharePoint and Access – I’ll point out a few. My good colleagues at MSDN offer a nice summary of Access 2003/WSS 2.0 integration, and the folks at TechNet have an integration overview for Access 2007/WSS 3.0. And of course, Office.com covers Access 2003/2007 WSS integration too – though we hope you’re using Access Services to build web apps on SharePoint 2010. Check out Build an Access database to share on the Web to see what you can do.
Have you got a web database that really rocks? Tell us all about it!