Today’s guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance.
As with most performance work, beauty is in the eye of the user. When users work against a server on the other side of the world, performance makes a difference. Data, after all, only travels as fast as the speed of light. Our goal for Access 2010 was to make the connections to SharePoint lists nearly as fast as local tables. Additionally, we had to ensure requests didn’t swamp the server, bottleneck throughout the network, or cause the client machine’s CPU or RAM to thrash. We found that caching data in local tables, combined with conservative usage of resources on the server, network and local machine, provided the best user experience.
This Access 2010 performance improvement builds upon the Access 2007 architecture. Read more…
For additional information about the latest release, check out the Access 2010 Intro series on the Access team blog.

Bharat Shah is the General Manager of Microsoft’s Online Services division. His group is responsible for taking Microsoft’s business productivity software to the cloud, essentially turning traditional utilty software (you buy, deploy, manage) into distributed (Internet/Intranet) hosted services. For enterprise customers to small businesses, being able to subscribe to software services versus taking on the responsibilities and costs associated with deployment and management of software systems is very compelling.
Steve Greenberg recently gave a great talk (rated in the top 7 of all sessions) at the SharePoint Developers Conference about how Access 2010 and Access Services enable organizations to provide better oversight of Access development. In episode three Steve and Clint walks you through the key points of this hit session.
When it comes to identity management intensive applications, it’s hard to top Sharepoint. Whether you are signing in a portal, accessing a document or using a webpart for reaching out to external web services, your identity is going to be the factor that drives it all.